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.
Syncfusion Feedback

Export to Excel in Essential Studio 4.2.0.37 ''s Grid

Thread ID:

Created:

Updated:

Platform:

Replies:

68187 Sep 11,2007 04:50 PM UTC Sep 12,2007 05:31 PM UTC Windows Forms 2
loading
Tags: GridControl
Kiran
Asked On September 11, 2007 04:50 PM UTC

Hi,

I would like to know if the Export to Excel feature for the Windows Forms Essential Grid control is available for the 4.2.0.37 version.

Thanks,
Kiran

J.Nagarajan [Syncfusion]
Replied On September 11, 2007 05:40 PM UTC

Hi Kiran,

The support to convert grid contents to excel uses XlsIo libraries. The dlls that these depends are Syncfusion.XlsIo.Base and Syncfusion.GridConverter.Windows.

The GridToExcel method should be used to export the grid to an excel sheet.

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
converter.GridToExcel(this.gridControl1.Model, saveFileDialog.FileName,GridExcelConverter.ConverterOptions.Default);

You could also import an excel sheet to the grid using the ExcelToGrid method.

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
gecc.ExcelToGrid( openFileDialog.FileName, this.gridControl1.Model);

From our version 4.2.0.37 ,we have shipped Essential XlsIo, which is a .NET library, that can read and write MS Excel files in a more efficient manner. Please refer to the Excel Export Sample for more details.

C:\Program Files\Syncfusion\Essential Studio\4.2.0.37\Windows\Grid.Windows\Samples\Quick Start\Excel Export\GridControl

Let me know if you need more information.

Thanks for using Syncfusion Products.

Regards,
Nagaraj

Kiran
Replied On September 12, 2007 05:31 PM UTC

Hi Nagarajan,

Thanks for the reply. I will try using the way you have mentioned.

Thanks,
Kiran

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.

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

;