Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

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 49 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 45 times
Page_Break_Preview.png
Page_Break_Preview.png (60.79 KiB) Viewed 304 times
User avatar

rachel.lei
 
Posts: 1514
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: 1514
Joined: Tue Jul 09, 2019 2:22 am

Return to Spire.XLS