Export selected columns from griddatabound to excel

[Marius Ovidiu Lancrangean]

Hi,

In my project, after using the FieldChooser, I need to export remaining columns to excel. How can I do this?

Marius

[Marius Ovidiu Lancrangean]

Ok. It was simple.

GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl();
 
		// Export the contents of the Grid to Excel
		converter.GroupingGridToExcel(this.grid, @"C:\temp\Export.xls", ConverterOptions.Visible | ConverterOptions.ColumnHeaders);

[Amal Raj U]

Hi Marius, 

Thanks for using Syncfusion products. 

We are glad to know that you have found the solution for your issue to export the visible columns using ConverterOptions. Please let us know, if you have any queries. 

Regards, 

Amal Raj U. 

[Marcus Ricardo Gomes Guedes]

        Dim converter As New GroupingGridExcelConverterControl()

        converter.GroupingGridToExcel(GridC100, "c:\temp\xxx.xls", Syncfusion.GridExcelConverter.ConverterOptions.ColumnHeaders)

Valor de tipo 'Syncfusion.Windows.Forms.Grid.Griddataboundgrid' não pode ser convertido para 'Syncfusion.Windows.Forms.Grid.Grouping.Gridgroupingcontrol'

Translate: Value type 'Syncfusion.Windows.Forms.Grid.Griddataboundgrid' cannot be converted to  'Syncfusion.Windows.Forms.Grid.Grouping.Gridgroupingcontrol'

Hello, i´m getting the error above. Plz help me to know how to export griddatabound to excel using vb.net.

thx

[Sindhu Nagarajan]

Hi Marcus, 

Thanks for contacting Syncfusion support. 

The GroupingGridExcelConverterControl class is used for exporting GridGroupingControl only. So, we request you to use GridExcelConverterControl class to export the GridDataBoundGrid control.  

Please refer to the below KB document to export data in GridDataBoundGrid to excel sheet. 

Code Example 

private void button1_Click(object sender, EventArgs e) 

{ 

    GridExcelConverterControl gecc = new GridExcelConverterControl(); 

    gecc.GridToExcel(this.gridDataBoundGrid1.Model, "xcel.xls");   

}    

KB Link: https://www.syncfusion.com/kb/4094/how-to-export-the-contents-of-a-grid-to-excel 

Please let us know if you have any other queries. 

Regards, 

Sindhu