String index out of range error

[Usha.Thavasiappan]

Hello experts,
I'm converting the XLSM file into a PDF file using Java Spire.office-8.10.2 API.
The source file "CivicPlus.xlsm" has been ended in error without converting a file.

The program gets an error on loading from a file itself.

Code: Select all

workbook.loadFromFile(file.getPath());

Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: 0
at java.base/java.lang.StringLatin1.charAt(StringLatin1.java:48)
at java.base/java.lang.String.charAt(String.java:1513)
at com.spire.office.packages.sprpqf.spr∯⌹(Unknown Source)
at com.spire.office.packages.spricg.spr⌮┃(Unknown Source)
at com.spire.office.packages.spricg.spr┶┄(Unknown Source)
at com.spire.office.packages.spricg.spr┹┃(Unknown Source)

The sample source code and a screenshot of the log details are attached.
I could not upload the source file in this thread. I will share the same with the support email.

I appreciate your help on this.

StrIndexError.zip

(48.05 KiB) Downloaded 581 times

[Annika.Zhou]

Hello,

Thank you for your inquiry.
Please send the Excel file you used to support@e-iceblue.com via email so that we can investigate your issue. Thank you in advance.

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello Annika,
I sent an email to the support email yesterday. But it failed to deliver due to "Recipient inbox full".

My source file is about 14MB in size. Is there any way to share the file with you?

[Annika.Zhou]

Hello,

Thank you for your feedback.
Please provide a download link for the document or share the document with us by adding our Skype account (iceblue.support).
Once we have access to the document, we will promptly proceed with the necessary analysis and address your concerns accordingly.
Thank you again for your collaboration.

Sincerely,
Annika
E-iceblue support team

[Usha.Thavasiappan]

Hello Annika,
I have shared the file StrIndexError-CivicPlus https://drive.google.com/file/d/1YSbtB-bHDqrU5nVl7lyIrHDITsGEhC73/view?usp=sharing. Please proceed further from your end.

[Ula.wang]

Hi,

Thank you for your feedback.
I have tested the file you provided and reproduced your issue. I have recorded this issue in our bug tracking system with the number "SPIREXLS-5024". Our development team will investigate and fix it in the future. If this issue is resolved, we will notify you as soon as possible. We deeply apologize for any inconvenience caused.

Sincerely,
Ula
E-iceblue support team

[Usha.Thavasiappan]

Hello,
Thanks for considering the issue as a bug.

I just want to know the limitation of the source file (Excel to PDF conversion) on the Spire.Office license version.
Like file size, number of sheets, etc.,

[Ula.wang]

Hi,

Thank you for your more inquiry.
Please kindly note that our product strictly complies with Microsoft Office standards, as you have purchased our commercial version of Spire.Office. Under the premise of following Microsoft Office rules, If you apply license correctly, currently has no restriction on the file size and number of pages for converting excel to pdf.

Sincerely,
Ula
E-iceblue support team

[Usha.Thavasiappan]

Hello,
Thank you for the details.

[Ula.wang]

Hi,

Thank you for your feedback.
If you have any issue, just feel free to write back. I hope you have a wonderful day.

Sincerely,
Ula
E-iceblue support team

[Usha.Thavasiappan]

Hello,
Kindly update on this bug status.

[Ula.wang]

Hi,

Thank you for your feedback.
Don’t worry, I have urged our Dev team to speed up fixing your issue. If there are any updates, I will inform you in time. We will do our best to help you.

Sincerely,
Ula
E-iceblue support team

[Doris.Liu]

Hi,

Thank you for your patience!
We have released Spire.Office 9.6.0, which contains the fix of the issue SPIREXLS-5024. Please download it from the following link to test.

Spire.Office for Java 9.6.0: https://www.e-iceblue.com/Download/office-for-java.html

Sincerely,
Doris
E-iceblue support team

[Usha.Thavasiappan]

Hello Doris,
Thanks for the update. But please take a reasonable duration to fix the issue.
I confirm that this bug (SPIREXLS-5024) has been fixed. I'm able to convert the document now.

[Doris.Liu]

Hello!

Thank you for your confirmation that the bug (SPIREXLS-5024) has been resolved and you are now able to convert the document successfully. We appreciate your patience and understanding while we worked to address this issue.
If you encounter any further issues or have any additional questions, please don't hesitate to reach out to us. We are here to help.
Have a great day!

Sincerely,
Doris
E-iceblue support team