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.
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?
Thanks for update and implemented .