Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri Jun 12, 2020 7:40 am

Hi,

I am using FreeSpire.XLS.

Using this code

Dim workbook As Spire.Xls.Workbook = New Spire.Xls.Workbook()
workbook.LoadFromFile(fileIn, Spire.Xls.ExcelVersion.Version2010)
workbook.SaveToFile(fileOut, Spire.Xls.FileFormat.PDF)

with fileIn the attached .xlsx file, the output (fileOut) is generate with only half page generation .pdf file (see attached.pdf)
What's wrong?

Desktop.zip
(61.11 KiB) Downloaded 168 times

AndreaLando
 
Posts: 2
Joined: Fri Jun 12, 2020 7:32 am

Fri Jun 12, 2020 8:26 am

Hello,

Thanks for your inquiry.
I opened your Excel file in Microsoft Excel and then switched to the Page Break Preview view, but found that there is only one page and it does not include all the content, see the attached screenshot. Thus, the content of the generated PDF document is just a part of the source document. Hope you can understand.
For your situation, please adjust the print area of your source document. And I also attached the modified file for your kind reference.

Sincerely,
Rachel
E-iceblue support team
Attachments
tmp1C2C_Modified.zip
(14.3 KiB) Downloaded 139 times
Page_Break_Preview.png
Page_Break_Preview.png (60.79 KiB) Viewed 801 times
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Fri Jun 12, 2020 8:55 am

Thanks,

works good!

AndreaLando
 
Posts: 2
Joined: Fri Jun 12, 2020 7:32 am

Fri Jun 12, 2020 9:19 am

Hello,

You are welcome.
If you encounter any issue related to our products in the future, just feel free to contact us.
Wish you all the best!

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Return to Spire.XLS