Bug when using ExportDocument to Excel
Posted: Thu Oct 17, 2019 1:47 pm
I'm trying to create an excel document with about 100,000 lines but I receive the error : "Index was outside the bounds of the array". I tried changing the export settings but no parameter seems to fix that error.
I tried saving the mdc and exporting in excel from the viewer and strangely enough it works. When testing, I saw that if I have over 65536 record then the export create a new page in excel, but the export with the viewer does not. So what configuration do I need to change to be able to export the same way as the viewer.
This is the stacktrace :
à Stimulsoft.Report.Export.StiExcelExportService.WriteToOLEContainer() dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\Export\Services\Office\StiExcelExportService.cs:ligne 2829
à Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\Export\Services\Office\StiExcelExportService.cs:ligne 3450
à Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, StiExportService exportService, Stream stream, StiExportSettings settings) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\StiReport.Export.cs:ligne 771
à Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, String file, StiExportSettings settings) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\StiReport.Export.cs:ligne 121
à Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, String file) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\StiReport.Export.cs:ligne 80
I tried saving the mdc and exporting in excel from the viewer and strangely enough it works. When testing, I saw that if I have over 65536 record then the export create a new page in excel, but the export with the viewer does not. So what configuration do I need to change to be able to export the same way as the viewer.
This is the stacktrace :
à Stimulsoft.Report.Export.StiExcelExportService.WriteToOLEContainer() dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\Export\Services\Office\StiExcelExportService.cs:ligne 2829
à Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\Export\Services\Office\StiExcelExportService.cs:ligne 3450
à Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, StiExportService exportService, Stream stream, StiExportSettings settings) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\StiReport.Export.cs:ligne 771
à Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, String file, StiExportSettings settings) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\StiReport.Export.cs:ligne 121
à Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, String file) dans D:\Stimulsoft\Stimulsoft.Reports\Stimulsoft.Report\StiReport.Export.cs:ligne 80