File not loaded-Excel to PDF conversion error

[Usha.Thavasiappan]

Hello experts,
I'm trying to convert an Excel file into a pdf using Java Spire.Office 8.9.5 jar version.
The source file "Compass Health Financials March 2023 Distribution.xlsx" has not been processed.
I just shared the sample source file and source code for your reference.
It is quite critical.

The source file can not proceed further after this code snippet.

Code: Select all

workbook.loadFromFile(file.getPath());

Test1.rar

(1.09 MiB) Downloaded 781 times

[Annika.Zhou]

Hello,

Thank you for your inquiry.
I tested your Excel file and did reproduce the issue you mentioned. I have logged the issue into our bug tracking system with the ticket number SPIREXLS-4996. Our development team will investigate and fix it. Once it is resolved, I will inform you in time. Sorry for the inconvenience caused.

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello Annika,
Thanks much for the acceptance.
I will be waiting for the solution.

[Annika.Zhou]

Hi,

You're welcome.
I will inform you promptly once there is any update regarding this issue.
Wish you all the best.

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello,
I hope the issue will be resolved soon.
May I know the current status or progress of this issue?

[Annika.Zhou]

Hello,

Thank you for your following up.
The issue SPIREXLS-4996 has been resolved and it is going to test phase now. If the test goes well, we will provide a hotfix for you as soon as possible. Please give us more time, thanks for your understanding.

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello,
Thanks for the update.
I hope it will be good to go.

[Usha.Thavasiappan]

Hello,
Any update on the solution for this bug?

[Annika.Zhou]

Hello,

Thanks for following up.
The issue SPIREXLS-4996 has been tested and we will release a new version with a fix for this issue within this month. Once the new version is available, I will let you know immediately. Thanks for your understanding.

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Thanks for your patience!
Glad to inform you that we just released Spire.Office for Java Version:8.12.0 which fixes the issue of SPIREXLS-4996.
Welcome to test it.

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello Annika,
Thanks for the update.
However, I could not find the latest version in the repository. Please help with this.

Spire-MVN.png (30.32 KiB) Viewed 4245 times

[Annika.Zhou]

Hello,

Thank you for your feedback.
Please refresh the webpage again, as the latest version of SPire.Office for Java has been successfully uploaded in its entirety.

SpireOfficeMVN.png (15.68 KiB) Viewed 4239 times

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello,
I'm still getting the same error after testing the SPIREXLS-4996 issue with the latest version.
Kindly look into this on priority.

Code: Select all

workbook.loadFromFile(file.getPath());

The stack trace is mentioned below for your reference.

com.spire.office.packages.spriona.<init>(ghg:208)
com.spire.office.packages.spriona.<init>(ghg:2)
com.spire.office.packages.spriona.<init>(ghg:93)
com.spire.office.packages.sprfpna.spr︼▌—(cog:661)
com.spire.office.packages.sprgsg.spr‱└(Unknown Source)
com.spire.office.packages.sprgsg.<init>(Unknown Source)
com.spire.xls.core.spreadsheet.XlsWorkbook.<init>(Unknown Source)
com.spire.xls.Workbook.loadFromFile(Unknown Source)
com.spire.xls.Workbook.loadFromFile(Unknown Source)
com.cs.SampleSingle.convertExcelToPdf(SampleSingle.java:56)
com.cs.SampleSingle.main(SampleSingle.java:31)
at com.spire.office.packages.spriona.<init>(ghg:208)
at com.spire.office.packages.spriona.<init>(ghg:2)
at com.spire.office.packages.spriona.<init>(ghg:93)
at com.spire.office.packages.sprfpna.spr︼▌—(cog:661)
at com.spire.office.packages.sprgsg.spr‱└(Unknown Source)
at com.spire.office.packages.sprgsg.<init>(Unknown Source)
at com.spire.xls.core.spreadsheet.XlsWorkbook.<init>(Unknown Source)
at com.spire.xls.Workbook.loadFromFile(Unknown Source)
at com.spire.xls.Workbook.loadFromFile(Unknown Source)
at com.cs.SampleSingle.convertExcelToPdf(SampleSingle.java:56)
at com.cs.SampleSingle.main(SampleSingle.java:31)

[Annika.Zhou]

Hello,

Thank you for your feedback.
I have tested the document mentioned in SPIREXLS-4996 using the latest version of Spire.Office, and I didn't encounter any issues. Attached are my test code and the resulting file for your reference.

Code: Select all

Workbook workbook = new Workbook();
workbook.loadFromFile("Compass Health Financials March  2023 Distribution.xlsx");
workbook.getConverterSetting().setSheetFitToPage(true);
workbook.saveToFile("result.pdf", FileFormat.PDF);
System.out.println("Document conversion successful!!!!");

Additionally, to assist us in further investigating your issue, please provide the following information. You could attach them here or send them to us via email ([email protected]). Thanks in advance.
1) Your test file (if any).
2) Your test environment, such as OS info (E.g. Windows 10, 64-bit) and region setting (E.g. China, Chinese).
3) The JDK version used in your test (such as JDK1.8 ).

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello,
Yes, it is working as expected. Thanks for your support.