Exporting datagrid to Excel in a Windows Application

[KC Eric]

Hi all,

I am trying to export the content of a datagrid to Excel format (xls) in
a Windows Application,

I google a bit, but the examples I found were focus on ASP.net, using
the response object, e.g.

HttpResponse response = HttpContext.Current.Response;
response.ContentType = "application/vnd.ms-excel";
How to achieve the same in a C# windows application?

Thanks a lot!
KC Eric

[Nicholas Paldino [.NET/C# MVP]]

Eric,

It would be very different. Your best bet is to either use the OLEDB
adapter for Excel/CSV files, or to populate a sheet using Excel automation.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"KC Eric" <[e-mail]> wrote in message
news:eb**************@TK2MSFTNGP05.phx.gbl...

Hi all,

I am trying to export the content of a datagrid to Excel format (xls) in
a Windows Application,

I google a bit, but the examples I found were focus on ASP.net, using
the response object, e.g.

HttpResponse response = HttpContext.Current.Response;
response.ContentType = "application/vnd.ms-excel";
How to achieve the same in a C# windows application?

Thanks a lot!
KC Eric

[mickwen]

There is .net component call spire.dataexport, I have heard that it is
quite good for generating Excel files. It can create Excel files
without MS Excel installed on the machine,Free download.
http://www.e-iceblue.com
KC Eric 写�：

Hi all,

I am trying to export the content of a datagrid to Excel format (xls) in
a Windows Application,

I google a bit, but the examples I found were focus on ASP.net, using
the response object, e.g.

HttpResponse response = HttpContext.Current.Response;
response.ContentType = "application/vnd.ms-excel";
How to achieve the same in a C# windows application?

Thanks a lot!
KC Eric