Syncfusion Grid - Limitaion on maximum number of worksheets/columns

Question

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 · Answer

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