We have been using ExcelExport in UltraWebGrid for several years now, and we never had any problems. Suddenly, on a special set of records, we get the following exception.
Has anyone seen this before? What does it mean?
----------
System.Exception: Internal: Record DataSize property returns different data length than real Data length isat Infragistics.Excel.BIFFRecordset.Write(BinaryWriter bw)at Infragistics.Excel.BIFF8Writer.WriteWorkbookToFile(Workbook workbook, String fileName)at Infragistics.Excel.BIFF8Writer.WriteWorkbookToStream(Workbook workbook, Stream outStream)at Infragistics.WebUI.UltraWebGrid.ExcelExport.UltraWebGridExcelExporter.Export(UltraWebGrid grid, Worksheet worksheet, Int32 startRow, Int32 startColumn)at Infragistics.WebUI.UltraWebGrid.ExcelExport.UltraWebGridExcelExporter.Export(UltraWebGrid grid)at eurosoft.WebUI.Pages.liste.liste_PreRender(Object sender, EventArgs e) in c:\\develop\\esinet\\eswebsales\\eswebui\\liste.aspx.cs:line 264at System.Web.UI.Control.OnPreRender(EventArgs e)at System.Web.UI.Control.PreRenderRecursiveInternal()at System.Web.UI.Page.ProcessRequestMain()
Hi eurosoftIT,
Thank you for posting in the community.
Can you provide some information about your exact product version and whether the issue is browser specific. Any additional information you can provide regarding the conditions under which the behavior is reproducable would help me to isolate the matter.
Please feel free to contact me with any further questions.
Hello Petar,
these are the files we are using:
20.02.2004 00:00 102.400 Infragistics.Excel.v3.1.dll27.01.2004 00:00 598.016 Infragistics.WebUI.Design.v1.dll27.01.2004 00:00 106.496 Infragistics.WebUI.Shared.v2.dll23.02.2004 00:00 77.824 Infragistics.WebUI.UltraWebGrid.ExcelExport.v3.dll21.02.2004 00:00 1.454.080 Infragistics.WebUI.UltraWebGrid.v3.dll20.02.2004 00:00 602.112 Infragistics.WebUI.UltraWebNavigator.v3.1.dll18.02.2004 00:00 237.568 Infragistics.WebUI.UltraWebTab.v2.1.dll20.02.2004 00:00 155.648 Infragistics.WebUI.WebDataInput.v1.dll20.02.2004 00:00 368.640 Infragistics.WebUI.WebDateChooser.v1.1.dll
The exception occurs in all browsers (tried Firefox, IE and Chrome).
When we devide the recordset into two parts and make separate Excel-exports for them, everything works fine. Maybe our recordset is too large?! Is there a maximal accepted size of the recordset?
Regards,
eurosoftIT
Thank you for your reply.
Please note that version 3 of .NetAdvantage is outdated and is no longer supported. I suggest that you consider upgrading to a newer version.
Though I am obviously unaware of the amount of data you are exporting, note that different Excel versions pose restrictions on the maximum number of rows and columns which can be placed in a single sheet which may be causing your issues:
http://msdn.microsoft.com/en-us/library/aa730921%28v=office.12%29.aspx
Note that since version 11.2, our classic ASP.NET controls have been retired. You can find a detailed list of the retired controls and their respective replacements at:
http://blogs.infragistics.com/blogs/taz_abdeali/archive/2011/11/17/asp-net-product-changes-in-2011-volume-2.aspx
Feel free to contact me if you have any questions.
Please do not hesitate to contact me if I can be of assistance.
Hi Petar,
the data amount should not be a problem, we're talking about 250 rows and 15 columns. Somehow it depends on the data, since exporting larger tables with different data is no problem.
We haven't decided about upgrading yet.
Thanks so far!
eurosoftIT.
Please feel free to contact me if I can assist you in any way.