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.

Tue May 11, 2021 7:42 am

Hi

I'm using spire.xls.free 3.9.2 JAVA.

Sometimes when open excel file via loadFromStream, below error occur.

Value too large or too small.


Could you give the reason that occur this issue?

Code: Select all
com.spire.xls.packages.sprQAC: Value too large or too small.
   at com.spire.xls.packages.spryyB.spr (jyc:591)
   at com.spire.xls.packages.spryyB.spr (jyc:422)
   at com.spire.xls.packages.spryyB.spr (jyc:221)
   at com.spire.xls.packages.sprseC.spr (rng:55)
   at com.spire.xls.packages.sprLHA.spr (Unknown Source)
   at com.spire.xls.packages.sprkGA.spr (Unknown Source)
   at com.spire.xls.packages.sprkGA.spr    (Unknown Source)
   at com.spire.xls.packages.sprYiA.spr  (Unknown Source)
   at com.spire.xls.packages.sprYiA.spr (Unknown Source)
   at com.spire.xls.packages.sprThA.spr (Unknown Source)
   at com.spire.xls.packages.sprxOa.spr (Unknown Source)
   at com.spire.xls.packages.sprxOa.<init>(Unknown Source)
   at com.spire.xls.core.spreadsheet.XlsWorkbook.<init>(Unknown Source)
   at com.spire.xls.Workbook.spr (Unknown Source)
   at com.spire.xls.Workbook.loadFromStream(Unknown Source)


Here is My code

Code: Select all
        Workbook workbook = new Workbook();
         workbook.loadFromStream(inputStream);


ccame8539
 
Posts: 7
Joined: Tue Apr 06, 2021 7:01 am

Tue May 11, 2021 9:17 am

Hello,

Thanks for your inquiry.
I noticed that you are using the free version of Spire.XLS for java. Since our latest commercial version contains more fixes, I recommend you download the latest Spire.XLS for Java Version:4.4.6 and try it again. If there are still any problems, please provide your input file to us for further investigation. You could upload your file here or send it to us (support@e-iceblue.com) via email. Thanks in advance.

Sincerely,
Brian
E-iceblue support team
User avatar

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

Wed May 19, 2021 10:00 am

Hello,

How is your issue now? Could you please give us some feedback at your convenience?

Sincerely,
Brian
E-iceblue suppport team
User avatar

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

Return to Spire.XLS