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 in Essential Studio 4.2.0.37 ''s Grid

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 01:40 PM

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 01:31 PM

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.

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.

;