Hi all,

I would like to export the datagridview to the excel spreadsheet.

Does anyone had an idea of how to do it?

Thanks

There is a great article on the code project about exporting a DataSetto an Excel file: Export a DataSet to Microsoft Excel without the use of COM objects.

There is a great article on the code project about exporting a DataSetto an Excel file: Export a DataSet to Microsoft Excel without the use of COM objects.

Now there is a great component that does the work. DataGridView Extension integrates in the DataGridView control and enables it to export data into Excel files, Html files ... soon and Pdf files (as the writers say). Also it allows searching for text in the DataGridView, change settings, persist made changes, make themes and many more.

http://www.completit.com/Products/DGVE/Overview.aspx

Here is a VB.net code to export Datagridview data to excel file