J.
J.Nagarajan
Syncfusion Team
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
KI
Kiran
September 12, 2007 05:31 PM UTC
Hi Nagarajan,
Thanks for the reply. I will try using the way you have mentioned.
Thanks,
Kiran