Export DataGrid to Excel in Windows Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Davy C - 17 Dec 2004 18:17 GMT

Does anyone know how to export a Windows forms datagrid to excel?
I have a datagrid and want to click a button an export the data to excel and
access.

Thanks!

Reply to this Message

Ed Kaim - 18 Dec 2004 00:31 GMT

The easiest way would be to export the values in comma separated value (CSV)
format.

I don't have code on hand, but there is an ASP.NET sample (which will need
to be changed for a client app) at
http://www.netomatix.com/GridExportToCSV.aspx. I haven't tried this code, so
you could search MSN or Google for more.

> Does anyone know how to export a Windows forms datagrid to excel?
> I have a datagrid and want to click a button an export the data to excel
> and
> access.
>
> Thanks!

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...