Export DataGridView to excel with specific columns

GemBox.Spreadsheet
1

Hi Team,

I am using GemBox.SpreadSheet.WinFormsUtility v37.00.xx with licence.
I want to export datagridview to excel, this is happening. But i want only specific columns to export, not all from datagridview.
Could you please guide me, how to do it.

Regards,
Girish

2

Hi Girish,

One solution could be to use DataGridViewColumn.Visible, the invisible DataGridView columns will be exported as invisible Excel columns. However, this feature is not available in older GemBox.Spreadsheet 3.7.

Another solution would be to filter out the data in the DataGridViewColumn data source or to remove the undesired columns from the control before exporting to an Excel file.

Does this work for you?

Regards,
Mario

3

Thanks for update and implemented .