Page does not display 2 row values after tabular data

[UshaThavasiappan]

Hello Experts,

Im converting XLSX file into PDF file using spire.xls-12.9.1 API.

Sample code, sample source file and the image of exact error highlighted are attached for your reference.

After displaying 40 rows of tabular data, 2 data rows are not converted in PDF file.

I really appreciate your help on this.

MissingDataIssue.zip

(169.96 KiB) Downloaded 89 times

[Simple.Li]

Hello,

Thanks for your inquiry.
Since your Excel file set a print area that didn't include the last two rows. You can use the following code snippet to cancel the print area, and then convert it. If you have any further questions, please feel free to contact us

Code: Select all

Worksheet worksheet = workbook.getWorksheets().get(0);
PageSetup pageSetup = worksheet.getPageSetup();
pageSetup.setPrintArea(null);


Sincerely,
Simple
E-iceblue support team

[UshaThavasiappan]

Hello Simple,
Your suggestion saved me . Thanks for your support.

[Lisa.Li]

Hello,

Glad to hear that, if there is anything else we can do for you in the future, just feel free to contact us!

Sincerely,
Lisa
E-iceblue support team