We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Page numbering using Aspose.Cells

Good afternoon.

We are copying worksheets from a variety of books into one overall book that will have a coverpage with a table of contents.

We need to be able to annotate the TOC with page numbers for each sheet, however we can find no way of working out the page number of each worksheet individually.

Could you advise if this is possible using Aspose.Cells?


We did see one suggestion to convert the worksheet into a pdf & work out the pages from this, hoever we are concerned about the overhead associated with such a process.

Any help you could offer would be greatly appreciated.


Danny Brown

Hi,

How could you add TOC in MS Excel manually (without using any macro as the component does not support to create macros). Could you create a sample Excel file having TOC in it or attached and post the file to us. We will check how to implement it using the API.

By the way, you can try to make your own TOC adding some internal hyperlinks for the workbooks sheets, see the document for reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/adding-hyperlinks-to-link-data.html


Thank you.