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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Syncfusion Grid - Limitaion on maximum number of worksheets/columns

Thread ID:





105915 Nov 28,2012 05:57 AM UTC Dec 14,2012 11:33 AM UTC WPF 1
Tags: GridControl
Asked On November 28, 2012 05:57 AM UTC

 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 [Syncfusion]
Replied On December 14, 2012 11:33 AM UTC

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.




GDCExport Copy_dca435e.zip


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

or the page will be automatically redirected to 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