We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

System.OverflowException occurred open workbook

Thread ID:

Created:

Updated:

Platform:

Replies:

100381 Aug 2,2011 08:37 PM UTC Dec 31,2012 07:58 AM UTC ASP.NET Web Forms (Classic) 5
loading
Tags: XlsIO
Allen Modine
Asked On August 2, 2011 08:37 PM UTC

I am trying to open a workbook with many worksheets and pivot tables. It used to work with version 8.4.0.10 but does not work with either 9.1.0.20 or 9.2.0.138. Since there are so many worksheets it is hard to narrow down what cell is causing the OverflowException. Can I send the file to you to review?

var excelEngine = new ExcelEngine();
var application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2007;

var workbook = excelEngine.Excel.Workbooks.Open(Path.Combine(_path, @"Template\" + SsrTemplate));




System.OverflowException occurred
Message=Value was either too large or too small for an unsigned byte.
Source=mscorlib
StackTrace:
at System.Byte.Parse(String s, NumberStyles style, NumberFormatInfo info)
at System.Xml.XmlConvert.ToByte(String s)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParseCacheRecordRow(XmlReader reader, PivotCacheImpl cache, Int32 currentRow, Int32 iFieldsCount)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParseCacheRecordRows(XmlReader reader, PivotCacheImpl cache, Int32 rowCount)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParsePivotCacheDefinition(XmlReader reader, PivotCacheImpl cache, IWorkbook book, String path, RelationCollection relations)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParsePivotCache(String strWorkbookPath, String relationID, String& strItemName)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParsePivotCaches(String strWorkbookPath)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseWorkbook(List`1& themeColors)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseDocument(List`1& themeColors)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseExcel2007Stream(Stream stream, String password)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseStream(Stream stream, String password, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseFile(String fileName, String password, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String strFileName, ExcelParseOptions options, Boolean bReadOnly, String password, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, String strTemplateFile, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String filename, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String filename)
at MorningSSRReportCreator.Program.ProductReport(Boolean fullReport) in D:\2008\MorningReportCreator\MorningSSRReportCreator\Program.cs:line 142
InnerException:



Jawahar Jeevanandan J [Syncfusion]
Replied On August 3, 2011 08:41 AM UTC

Hi Allen,

Thank you very much for using syncfusion products.

Could you please update us the input file that reproduces the issue, so that we can analyze in detail and provide you a proper solution.

Please let us know if you have any clarifications.

Thanks,
Jawahar.


Allen Modine
Replied On August 3, 2011 12:30 PM UTC

here is the file, thanks



SSRTemplate_b80f2e22.zip

Jawahar Jeevanandan J [Syncfusion]
Replied On August 4, 2011 05:41 AM UTC

Hi Allen,

Thank you very much for your update.

We have tried to open the excel file with our essential studio version 8.4, 9.1 and 9.2. But we could not able to see the reported issue form our side posted in your last update. We have placed the sample tested at our side along with video snap shot for the same in the below link. Please try this at your side and let us know if this helps you.

Sample link: http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=Sample-1379753302.zip

Video link: http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=OverflowException-413911702.zip

Please let us know if you have any clarifications.

Thanks,
Jawahar.


Administrator [Syncfusion]
Replied On December 10, 2012 11:18 AM UTC

Hi everybody,

I've got exactly the same problem.
Have you found an issue of it?

That's very important for me.

Thanks for your help.

Sridhar [Syncfusion]
Replied On December 31, 2012 07:58 AM UTC

Hi Nicolas,

We are sorry for the delay in getting back to you.

Could you please get back to us with the excel file which reproduces the above reported Overflow exception so that it will be helpful for us to proceed further on this. Also, please get back to us with the Stact trace of an above error and the Essential Studio version to analyze more on this.

Please let me know if you require any further clarifications.

Thanks,
Sridhar.S


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;