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

WinForms Grid ->Exporting to Excel 2007 using release

Thread ID:





93709 Mar 30,2010 02:38 PM UTC Mar 31,2010 08:57 AM UTC WinForms 1
Tags: GridControl
Asked On March 30, 2010 02:38 PM UTC

Was wondering if anyone could supply some answers to the following question:

Does the Windows Grid in Syncfusion support exporting to Excel 2007 formats? We want to migrate our windows application away from using Excel 2003 to Excel 2007. Updating our version of syncfusion is not currently in project scope.

I am guessing this relates to the following object in the supporting namespace :


Would appreciate any documentation/information/limitations.



Jisha Joy [Syncfusion]
Replied On March 31, 2010 08:57 AM UTC

Hi Jeff,

Yes. Essential Studio v6.3.0.6 support export to Excel 2007. To convert the grid content to an Excel 2007, you have to explicitly set the ExcelVersion by creating an XlsIO application and exporting the grid contents to its sheet. See the code:

ExcelEngine engine = new ExcelEngine();
IApplication app = engine.Excel.Application;
app.DefaultVersion = ExcelVersion.Excel2007;
IWorkbook book = app.Workbooks.Create();
GroupingGridExcelConverterControl gecc = new GroupingGridExcelConverterControl();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = 'Files(*.xlsx)|*.xlsx';
saveFileDialog.DefaultExt = '.xlsx';
if (saveFileDialog.ShowDialog() == DialogResult.OK)
gecc.GroupingGridToExcel(this.gridGroupingControl1, book.Worksheets[0], ConverterOptions.Visible);
if (MessageBox.Show('Do you wish to open the xls file now?', 'Export to Excel', MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
Process proc = new Process();
proc.StartInfo.FileName = saveFileDialog.FileName;

Sample for your reference:


Please let me know if this helps.



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