Syncfusion Grid - Limitaion on maximum number of worksheets/columns

[Sunil]

Hi
 I am using syncfusion grid and trying to export grid data to excel. My grid contains more than 800 columns. As there is a limitation on maximum number of columns i exported data to 2 work sheets , but still some columns are missing. Is it possible to change the limitaion on Number of worksheets or number of columns in a worksheet.

Is there any direct method which exports the entire data into an excel with same format ,pictures and merging of cells??        

[Divya A]

Hi Sunil,

 

Apologize for the delay caused.

 

To limit the number of columns to Export in a WorkSheet, you can pass a range of cells and the worksheet  in ExportToExcel() method as in the following code snippet.

 

 

Code Snippet:

 

 grid.ExportToExcel(GridRangeInfo.Cells(1,0,250,200), worksheet1, range);

 grid.ExportToExcel(GridRangeInfo.Cells(1,201,250,400), worksheet2, range);

 

 

 

Our Export method provides default support for Exporting Images and Formats to Excel.

 

We have created a sample based on your requirement and it can be downloaded from the following location.

 

Please let us know if you any concerns.

 

Regards,

Divya.

GDCExport Copy_dca435e.zip