Error when exporting excel : Too many regions with error indicators. Please reduce them before saving.

[hieudt]

Hi,

When exporting, this error happens

System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: Too many regions with error indicators. Please reduce them before saving.
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.SerializeErrorIndicators(OffsetArrayList records)
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.Serialize(OffsetArrayList records, Boolean bClipboard)
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.Serialize(OffsetArrayList records)
   at Syncfusion.XlsIO.Implementation.WorkbookImpl.WorkbookExcel97Serializator.Serialize(OffsetArrayList records, ExcelSaveType saveType, IEncryptor encryptor, WorkbookImpl book, WorksheetImpl sheet, Boolean forClipboard)
   at Syncfusion.XlsIO.Implementation.WorkbookImpl.WorkbookExcel97Serializator.Serialize(String fullName, WorkbookImpl book, ExcelSaveType saveType)
   at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType, ExcelVersion version)
   at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName)
   at Syncfusion.XlsIO.Implementation.WorkbookImpl.Close(Boolean SaveChanges, String Filename)
   at Syncfusion.GroupingGridExcelConverter.GridGroupingExcelConverterControl.ExportToExcel(GridGroupingControl grid, String excelFileName, ExcelExportingOptions exportingOptions)

Below is my code

                    GridGroupingExcelConverterControl excelConverter = new GridGroupingExcelConverterControl();
                    if (excel2003)
                        excelConverter.ExcelVersion = ExcelVersion.Excel97to2003;
                    else
                        excelConverter.ExcelVersion = ExcelVersion.Excel2010;
                    excelConverter.ShowGridLines = true;
                    excelConverter.ExportStyle = false;
                    excelConverter.ExportBorders = true;

                    ExcelExportingOptions exportingOptions = new ExcelExportingOptions();
                    excelConverter.ExportToExcel(this.grdList, saveFileDialog.FileName, exportingOptions);

Please help

Tks

[Jagadeesan Pichaimuthu]

Hi Hieudt, 

  

Thanks for using Syncfusion product. 

  

We have tried to reproduce your reported scenario using below attached sample with 100k rows and 10 columns in our latest Syncfusion product version 17.2.0.28. But the sample is working fine as we expected. So, please let us know the following details. 

  

1.       Provide the rows, columns count, datatype(int, string, double, etc) details and column setting if you have any. 

2.       Provide your current Syncfusion product version details. 

3.       Let us know the below attached sample differ from your customization.  

              Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CS1837123811 

 

Please provide the above requested information, it will be helpful for us to investigate further and provide the solution at the earliest. 

  

Regards, 

Jagadeesan