Creating reports and dashboards | Stimulsoft community forum

Hello!

I discovered a problem during excel export of documents. I have a really huge report - more than 7500 pages on a rendered report, number of lines over 100000 -, and I am unable to export it to excel (pdf works fine). The excel export ends with the following excetion:
Unhandled Exception: System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Stimulsoft.Report.Export.StiExcelExportService.dwFill(Int32 position, Byte dataValue, Int32 count)
at Stimulsoft.Report.Export.StiExcelExportService.WriteToOLEContainer()
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, StiExportService exportService, Stream stream, StiExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, Stream stream, StiExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, String file, StiExportSettings settings)
Also the memory consumption was also quite high, before the exception it was over 2 GB. Could you please look at the exception? Thank you.

Jozef

Hello.

Which version do you use?
Please, try the latest prerelease build. There was an improvement.

Thank you.

Unfortunately it did not help, I've tried the version 2013.1.1512, but the problems still persist. I tried to do the export from the designer - the same problem
----------------------------
[Customer Explanation]



----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework: v4.0.30319
Version: Version: 2013.1.1512 from 11 March 2013
MachineName: WKS-BALGA
OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
UserName: balga

----------------------------
[Exception Info]
Message: Index was outside the bounds of the array.

Source: Stimulsoft.Report

StackTrace:
at Stimulsoft.Report.Export.StiExcelExportService.dwFill(Int32 position, Byte dataValue, Int32 count)
at Stimulsoft.Report.Export.StiExcelExportService.WriteToOLEContainer()
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, StiExportService exportService, Stream stream, StiExportSettings settings)
at Stimulsoft.Report.Export.StiExportService.DoExport(StiExportInfo info)
at Stimulsoft.Report.Export.StiExportService.StartExport(StiReport report, Stream stream, StiExportSettings settings, Boolean sendEMail, Boolean openAfterExport, String fileName, StiGuiMode guiMode)
at Stimulsoft.Report.Export.StiExcelExportService.form_Complete(IStiFormRunner form, StiShowDialogCompleteEvetArgs e)
at Stimulsoft.Report.Export.StiExcelExportService.Export(StiReport report, String fileName, Boolean sendEMail, StiGuiMode guiMode)
at Stimulsoft.Report.Export.StiExportService.Export(StiReport report, String file, Boolean sendEMail)
at Stimulsoft.Report.Viewer.StiViewerControl.cmExport_Click(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 2.0.0.0
Stimulsoft.Base, Version = 2013.1.1512.0
Stimulsoft.Report, Version = 2013.1.1512.0
Stimulsoft.Report.Design, Version = 2013.1.1512.0
System.Windows.Forms, Version = 2.0.0.0

Let me clarify my problem a bit more - I would like to do an export to Excel 97-2003 format. Is it possible to do that with this amount of data?
Thank you for the response.

Hello,

We couldn't reproduce this bug.
Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.