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.
Unfortunately, activation email could not send to your email. Please try again.

Export to excel - WorkSheet and Column limitation

Thread ID:

Created:

Updated:

Platform:

Replies:

105967 Nov 30,2012 07:50 AM Dec 5,2012 05:53 AM Windows Forms 3
loading
Tags: GridControl
Gautham Prabhu
Asked On November 30, 2012 07:50 AM

Hi,
  I am using Syncfusion grid in my project which has more than 800 columns. I am trying to export it to excel using Syncfusion.XlsIo ExcelEngine . I tried exporting all the columns to same work sheet but it seems there is a limitation of 256 columns per worksheet. So i scattered the data into 3 worksheets. And again there is a limitation of 3 worksheets per workbook. How can i export the remaining columns data into excel. Is it really a limitation of XlsIo ExcelEngine or am i doing some thing wrong.       

Vinish Kumar K [Syncfusion]
Replied On December 4, 2012 02:19 AM

Hi Gautham Prabhu,

 

Thanks for your interested in Syncfusion products.

 

Query

Export to Excel.

In Excel version 2003 only support 256 column in worksheet. To export all columns in excel please use the letter version of MS Excel ( after 2007). And also changed some code changes in Export operation.

 

ExcelEngine engine = new ExcelEngine();

            IApplication app = engine.Excel.Application;

            app.DefaultVersion = ExcelVersion.Excel2010;

            IWorkbook book = app.Workbooks.Create(1);

 

            Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();

 

            SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.Filter = "Files(*.xls)|*.xls";

            saveFileDialog.DefaultExt = ".xlsx";

 

Please use the yellow heighted codes in your sample. If it doesn’t works for you please provide any sample file which is reproduce the issue.


Please let me know if you have further concerns.

Regards,

Vinish.


Gautham Prabhu
Replied On December 4, 2012 11:05 PM

Thank you. It is working fine with office 2010 with syncfusion 10.3. May i know from which version this app.defaultVersion property available. I am using syncfusion 4 version and this property is not available.                       

Vinish Kumar K [Syncfusion]
Replied On December 5, 2012 05:53 AM

Hi Gautham Prabhu,

 

Thanks for your update.

 

The app.defaultVersion property is available from the Syncfusion Essential Version 8.4.0.10. if you want to use this method  for your application. please migrate to our latest version.

Please let me know if you have further concerns.

Regards,

Vinish.


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.

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.

;