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
AD
Administrator
Syncfusion Team
April 19, 2006 03:06 PM UTC
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
Ga
April 19, 2006 06:43 PM UTC
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
>
AD
Administrator
Syncfusion Team
April 19, 2006 09:49 PM UTC
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
>>