Export a Virtusal grid To Excel

[e.davidse]

Could somebody tell me how to export a virtual grid to excel?

Regards

Erwin

[haneefm]

Hi Erwin,

The Excel Export browser ( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Windows\Samples\Serialization\ExcelExport_GridControl\ ) sample demonstrates the conversion of contents in a GridControl to an xls file and also the conversion of contents in an xls file to a gridControl. XlsIO libraries are used to support the conversion of grid contents to excel. The dlls that these depend on are Syncfusion.XlsIO.Base and Syncfusion.GridConverter.Windows. Here is a code snippet to show this.

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
gecc.GridToExcel(this.gridControl1.Model, "FileName");

Best Regards,
Haneef

[e.davidse]

The problem is that we don't use the Model. We fill the data structure on demand

Regards Erwin

[haneefm]

Hi Erwin,

Here is a minimal sample that show you "How to export the data from virtual grid to excel?". Please refer to the attached sample for implementation and let me know if this helps.
ModifiedVirtualGrid.zip

Best regards,
Haneef