Export to Excel in Essential Studio 4.2.0.37 ''s Grid

[Kiran]

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]

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]

Hi Nagarajan,

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

Thanks,
Kiran