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.

Wed Aug 04, 2021 7:03 am

Hi,
These's an XLSX file on my computer which cannot get loaded by Spire Office.

Here's the file:
charts.xlsx.zip
(30.21 KiB) Downloaded 319 times


[ ENV ]
OS: Windows 10 Pro 2004
JRE: OpenJDK Runtime Environment (build 1.8.0_275-b01)
Free Spire.Office for Java (3.9.0)

Here's the testing code:

[ Src Code ]
Code: Select all
import com.spire.xls.*;
import java.io.*;

public class ExcelToImage {
    public static void main(String[] args) throws IOException {
        //Create a workbook instance
        Workbook workbook = new Workbook();
        //Load the Excel file
        workbook.loadFromFile(args[0]);

        //Get the first worksheet
        Worksheet sheet = workbook.getWorksheets().get(0);

        //Save the sheet to image
        sheet.saveToImage("image.png");
    }
}


[ Error ]
Code: Select all
Exception in thread "main" class com.spire.office.packages.sprxua: DocPropsCustom root element eror
com.spire.office.packages.sprxhA.spr  (Unknown Source)
com.spire.office.packages.sprxhA.spr (Unknown Source)
com.spire.office.packages.sprRIA.spr  (Unknown Source)
com.spire.office.packages.sprRIA.spr (Unknown Source)
com.spire.office.packages.sprThA.spr  (Unknown Source)
com.spire.office.packages.sprrua.spr  (Unknown Source)
com.spire.office.packages.sprrua.spr  (Unknown Source)
com.spire.office.packages.sprrua.<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)
ExcelToImage.main(ExcelToImage.java:9)
   at com.spire.office.packages.sprxhA.spr  (Unknown Source)
   at com.spire.office.packages.sprxhA.spr (Unknown Source)
   at com.spire.office.packages.sprRIA.spr  (Unknown Source)
   at com.spire.office.packages.sprRIA.spr (Unknown Source)
   at com.spire.office.packages.sprThA.spr  (Unknown Source)
   at com.spire.office.packages.sprrua.spr  (Unknown Source)
   at com.spire.office.packages.sprrua.spr  (Unknown Source)
   at com.spire.office.packages.sprrua.<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 ExcelToImage.main(ExcelToImage.java:9)


Please help me handle the problem. Thanks

seanlin0800
 
Posts: 2
Joined: Fri Dec 25, 2020 6:55 am

Wed Aug 04, 2021 9:53 am

Hello,

Thanks for your inquiry.
I tested your case and did reproduce your issue, I have logged it in our bug tracking system with the ticket SPIREXLS-3385. If there is any update, we will let you know.
Besides, please kindly note that we only update the free version irregularly. All new features and bug fixes are included in the commercial version first. Apologize for the inconvenience caused.

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Thu Sep 09, 2021 12:23 pm

Hello,

Greetings from E-iceblue!
Glad to inform you that we just released Spire.Office for Java Version:4.9.2 which fixes your issue, please download it from the following links to test on your side. Looking forward to your test result.
Website link: https://www.e-iceblue.com/Download/office-for-java.html
Maven link: https://repo.e-iceblue.com/nexus/conten ... ice/4.9.2/

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Return to Spire.XLS