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.