How do I export the contents of Essential Grid to Excel using XlsIO?

You can export the contents of Essential Grid to an Excel spreadsheet using Essential Grid and Essential XlsIO. All the formatting and the contents of the grid are exported to the Excel spreadsheet using GridExcelConverterControl. However, since there is a difference in the feature set of Essential Grid and MS Excel, the closest equivalents are found in the exported file in case an exact equivalent could not be found. Since Essential XlsIO is a standalone library, it gives more flexibility to the developer while exporting the contents of the Grid to Excel. ConvertOptions enumerator provides four options for conversion. These helps in customizing the grid to Excel conversion.

Here is a code snippet

C#

//Export To Excel

GridExcelConverterControl converter = new GridExcelConverterControl();

converter.GridToExcel( gridControl1,"Sample.xls",ConverterOptions.Default);

VB

'Export To Excel

Dim converter As GridExcelConverterControl = New GridExcelConverterControl()

converter.GridToExcel(gridControl1,"Sample.xls",ConverterOptions.Default)

Here is a sample:

Excel Export Sample