When the attached Excel converted to PDF then only the first row of a sheet appears in PDF.
Code is:
PdfSaveOptions saveOptions = new PdfSaveOptions();
workbook.save(“Test01-out.pdf”, saveOptions);
Best regards, Evgeniy
Hi,
Thanks for your template files.
Well, this is not an issue with the product by any means. When I opened your template Excel file into MS Excel manually. I found there is a printable Area set in your template file sheet (In MS Excel, open the PageSetup dialog box Sheet tab and can see “A1:E1” in the Print Area field). Well, you may either remove this area manually (in MS Excel) to resave the file to print everything on the sheet in the rendered PDF file Or you may do it via Aspose.Cells APIs before rendering to PDF, it would work fine:
e.g
Sample code:
…
workbook.getWorksheets().get(0).getPageSetup().setPrintArea("");
…
Let us know if you still have any issue.
Thank you.
Hi Amjad,
Thanks a lot for the hint!
Best regards, Evgeniy
Hi,
Good to know that your issue is sorted out by the suggested code. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.
Thank you.