We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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


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;
                        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


1 Reply

JP Jagadeesan Pichaimuthu Syncfusion Team July 5, 2019 11:20 AM UTC

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 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.  
Please provide the above requested information, it will be helpful for us to investigate further and provide the solution at the earliest. 

Live Chat Icon For mobile
Up arrow icon