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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

145717 Jul 5,2019 04:56 AM UTC Jul 5,2019 11:20 AM UTC WinForms 1
loading
Tags: GridGroupingControl
hieudt
Asked On July 5, 2019 04:56 AM UTC

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon