A table is not displayed in PDF

Aspose.Cells Product Family
1

I attach source xlsx and resulting pdf. In the xlsx is a small table. She doesn’t appear in PDF

2

Hi,


Well, the reason is simple, if you could open your template file into MS Excel and check the PageSetup|Sheet tab’s printable area, you will see that it has “A1:AA42” value set, so the rendered PDF would not include any range/data outside of that area, see the screen shot attached. You should remove that area either manually in Ms Excel to re-save the template file or by using Aspose.Cells APIs before rendering to PDF,
e.g
Sample code:

workbook.Worksheets[“Datenblatt”].PageSetup.PrintArea = “”;

Hope, this helps you a bit.

Thank you.

3

Thanks for this Workaround, but that doesnt really help us.
You see we have many Excel documents, that we need to Change.

Any other idea?

4

Hi,


Well, this is not the issue with Aspose.Cells by any means. Aspose.Cells, similar to MS Excel renderer, renders Excel file to PDF file format based on what is shown in Print Preview of MS Excel for the sheets. As I suggested, you should remove that area accordingly to render all the contents in the sheet(s), you may try using Aspose.Cells APIs to do the task before rendering to PDF in your code segment:
e.g
Sample code:

workbook.Worksheets[“Datenblatt”].PageSetup.PrintArea = “”;


Thank you.

5

I see. Thanks for you help and I’m sorry that it took so Long.

6

Hi,


You are welcome. Feel free to contact us if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.