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.
Unfortunately, activation email could not send to your email. Please try again.

Open huge xls fail

Thread ID:

Created:

Updated:

Platform:

Replies:

43188 Apr 18,2006 04:34 AM Apr 19,2006 05:49 PM Windows Forms 3
loading
Tags: XlsIO
Ga
Asked On April 18, 2006 04:34 AM

Hi, I try to open an 4mb xls file an get the following exception. The code works fine with other little files. The Xls File is very complex, using macros and other utilities Excel provides. e.g. locked cells ... so I don''t think the size of the file is the issue. Can somebody help me. A list of things not to do when using xlsio ??? Thanks Tobias ArgumentOutOfRangeException ex.message Parameter name: length Actual value was 120. ex.stacktrace at Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.CheckOffsetAndLength(Int32 offset, Int32 length) at Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.GetBytes(Int32 offset, Int32 length) at Syncfusion.XlsIO.Parser.Biff_Records.OBJRecord.GetSubRecord(Int32 offset) at Syncfusion.XlsIO.Parser.Biff_Records.OBJRecord.ParseStructure() at Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.ParseStructure(Byte[] arrData, Int32 iOffset, Int32 iLength) at Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.FillRecord(BinaryReader reader, Byte[] arrBuffer) at Syncfusion.XlsIO.Parser.BiffRecordFactory.GetRecord(TBIFFRecord type, BinaryReader reader, Byte[] arrBuffer) at Syncfusion.XlsIO.Parser.BiffReader.GetRecord() at Syncfusion.XlsIO.Implementation.WorksheetBaseImpl.Parse(BiffReader reader, ExcelParseOptions options, Boolean bSkipParsing) at Syncfusion.XlsIO.Implementation.WorksheetImpl..ctor(IApplication application, Object parent, BiffReader reader, ExcelParseOptions options, Boolean bSkipParsing) at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorksheet(Object parent, BiffReader reader, ExcelParseOptions options, Boolean bSkipParsing) at Syncfusion.XlsIO.Implementation.Collections.WorksheetsCollection.Add(BiffReader reader, ExcelParseOptions options, Boolean bSkipParsing) at Syncfusion.XlsIO.Implementation.WorkbookImpl.ReadWorksheetsData(BiffReader reader, ExcelParseOptions options, Int32 iFirstSheet, Int32 iLastSheet) at Syncfusion.XlsIO.Implementation.WorkbookImpl.Parse(BiffReader reader, ExcelParseOptions options) at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName, ExcelParseOptions options) at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, String strTemplateFile) at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String Filename) at Syncfusion.XlsIO.ExcelUtils.CreateWorkBookUsingTemplate(String templateLocation) at test_xlsio.Button1_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\osc\test\xlsio.aspx.cs:line 35 ex.TargetSite CheckOffSetAndLength(int,int) ComPlusExceptionCode: -532459699

Administrator [Syncfusion]
Replied On April 19, 2006 11:06 AM

Hi Tobias, Sorry for the delay in getting you. I tried to reproduce the problem using a template file of 4MB size having Macros and other formats including locked cells but was unable to see problem. Could you please send the template file that produce this problem. Also, Could you please let me know how much memory it took to open, modify and save the file. You can also open a Direc-Trac incident so that the attachment remains confidential. BestRegards, Bharath

Ga
Replied On April 19, 2006 02:43 PM

Thank you for answering! I opened already a Direct-Trac: DirectTrac/user/details.aspx?id=24886 I was not able to upload the file, so I sent an email to ''support@syncfusion.com''. Hope to get help. Thank you Regards Tobias >Hi Tobias, > >Sorry for the delay in getting you. > >I tried to reproduce the problem using a template file of 4MB size having Macros and other formats including locked cells but was unable to see problem. > >Could you please send the template file that produce this problem. > >Also, Could you please let me know how much memory it took to open, modify and save the file. > >You can also open a Direc-Trac incident so that the attachment remains confidential. > >BestRegards, > >Bharath >

Administrator [Syncfusion]
Replied On April 19, 2006 05:49 PM

Hi Tobias, I have updated the issue in Direc-Trac. Best regards, Bharath. >Thank you for answering! > >I opened already a Direct-Trac: DirectTrac/user/details.aspx?id=24886 > >I was not able to upload the file, so I sent an email to ''support@syncfusion.com''. > >Hope to get help. Thank you > >Regards Tobias > > >>Hi Tobias, >> >>Sorry for the delay in getting you. >> >>I tried to reproduce the problem using a template file of 4MB size having Macros and other formats including locked cells but was unable to see problem. >> >>Could you please send the template file that produce this problem. >> >>Also, Could you please let me know how much memory it took to open, modify and save the file. >> >>You can also open a Direc-Trac incident so that the attachment remains confidential. >> >>BestRegards, >> >>Bharath >>

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.

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.

;