in excel to PDF conversion last row of Excel is clipped off. Our client has used custom formatting in excel, while the conversion to PDF seems to work well, the only defect is that the last row is missing the resulting pdf.
aspose_submit.zip (11.4 KB)
Attaching the excel file to this ticket.
Note: We are using licensed verison of Aspose libraries
Code Snippet
Workbook workbook = new Workbook(source);
workbook.save(out, SaveFormat.PDF);
This is not an issue rather it is due to printable area (i.e., “A1:F36”) set for the sheet in your Excel file (the last row is not included in the printable area set for the sheet). You may either set/update printable area to include the last row as well or remove the print area so the PDF file could be rendered fully. You may do that either in MS Excel manually or using the following sample code via Aspose.Cells APIs:
e.g
Sample code:
Workbook workbook = new Workbook(source);
Worksheet sheet = workbook.getWorksheets().get(0);
//sheet.getPageSetup().setPrintArea("A1:F37");
//Or remove the printable area
sheet.getPageSetup().setPrintArea("");
workbook.save(out, SaveFormat.PDF);
Let us know if you still find any issue.