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.

Fri Sep 29, 2017 9:51 pm

Hi,

Im creating XL file throught spire XLS, then make Pivot table

Code: Select all
 
var source = ws.Range[first_table_row, 1, last_row_used, ws.LastColumn];
PivotCache cache = workbook.PivotCaches.Add(source);

var wsPT = workbook.Worksheets[1];

PivotTable pt = wsPT.PivotTables.Add(prm[2], wsPT.Range["A1"], cache);


and save

Code: Select all
 workbook.SaveToFile(filename.Split(".".ToCharArray(), StringSplitOptions.RemoveEmptyEntries)[0] + "_обр" + ".xlsx", ExcelVersion.Version2010);

But when trying to open - there is "System.OverflowException" в mscorlib.dll: the value was too low or too large for Int32.

If i open and save this file throught Excel App - it will be all OK. Using last hotfix dll did not fix the problem. What can i do?
XL file makes Exception attached. Thanks a lot.
Attachments
File.rar
(404.57 KiB) Downloaded 255 times
Last edited by rvkstudent on Sat Sep 30, 2017 5:50 am, edited 3 times in total.

rvkstudent
 
Posts: 4
Joined: Fri Sep 29, 2017 9:25 pm

Sat Sep 30, 2017 2:50 am

Dear rvkstudent,

Thanks for your inquiry.
Sorry that I didn't find your attachments here, could you please upload it again ? And you also could send it to us(support@e-iceblue.com) via email.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Sat Sep 30, 2017 5:17 am

Attachment done.

rvkstudent
 
Posts: 4
Joined: Fri Sep 29, 2017 9:25 pm

Sat Sep 30, 2017 5:56 am

Dear rvkstudent,

Thanks for your email.
I have reproduced the issue and logged it into our bug system. If there is any progress, we will let you know.
Sorry for the inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Sat Sep 30, 2017 6:14 am

What can i do now to continue working?

rvkstudent
 
Posts: 4
Joined: Fri Sep 29, 2017 9:25 pm

Sat Sep 30, 2017 6:42 am

Dear rvkstudent,

I am afraid the way to solve this issue is waiting for the hotfix.
We will let you know once there is any progress.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri Oct 20, 2017 7:44 am

Dear rvkstudent,

Thanks for waiting.
Now the issue has been resolved in Spire.XLS Pack Hotfix Version:7.12.100.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Oct 24, 2017 8:56 am

Dear rvkstudent,

Greetings from E-iceblue.
Has your issue been resolved ?
Your feedback would be greatly appreciated.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS