Speadsheet Header, damaged Export PDF

[GHWels]

Hey!

Spreadsheet1.load('Test-Original.xlsx')
Spreadsheet1.SaveToFile("Test-Export.xlsx")
Spreadsheet1.SaveToFile("Test-Export.pdf", Spire.Xls.FileFormat.PDF)

1.) The "Test-Original.xlsx" has a header with a LOGO
2.) The "Test-Export.xlsx" has lost the LOGO
3.) The "Test-Export.pdf" is damaged.

Do you have any help?

[Nina.Tang]

Hello,

Thanks for your inquiry and sorry for late reply as weekend.
I did notice the header information lost issue with an old Spire.SpreadSheet, sorry for that. And I can confirm the issue doesn't exist in the latest Spire.Office Platinum Version:3.0 which contains the latest Spire.SpreadSheet.dll 2.3.1. Please reference the four dlls (Spire.Spreadsheet.dll Spire.XLS.dll Spire.Pdf.dll Spire.License.dll) from Spire.Office package and try again. As for the damaged issue, Spire.SpreadSheet doesn't support converting to other formats like PDF, you should use the function of Spire.Xls to do conversion such as below. If there is still any issue, please provide your "Test-Original.xlsx" for testing.

Code: Select all

Workbook wb = new Workbook();
wb.LoadFromFile("Test-Original.xlsx'");
wb.SaveToFile("Test-Export.pdf", Spire.Xls.FileFormat.PDF);

Sincerely,
Nina
E-iceblue support team

[GHWels]

Hey Nina!
Thank you for your fast help.
GH

[Nina.Tang]

Hi GH,

Thanks for your quick response.
I am wondering if your issues have been fixed in the latest Spire.Office? Could you please give us some feedback at your convenience? Thanks in advance.

Best wishes,
Nina
E-iceblue support team