GridView to Excel

[MGunawan]

Dear all

Any body know / have some function to convert GridView to Excel, please sharing to me, I need this function immediately.

TQ

[Hack]

Assuming the GridView is being populated from a database table, why not just dump the database records to excel and avoid the middle man?

[MGunawan]

Thanks for you response

But ... my gridview populate from List.

[Hack]

List? What kind of list?

[MGunawan]

List<DAL.Employee> lstEmployee = objEmplyee.List();

in objEmployee.List i have select several tables that I joint, in Gridview I used unbound data, so i just set on DataPropertyName. That I want export all data in gridview.

[Hack]

i have select several tables that I joint

So, you are using database tables, right?

Then just dump them directly to Excel.

[Sonia]

So, you are using database tables, right?

Then just dump them directly to Excel.

Hack,
I'd appriciate if u share me the code sample for exporting gridview to excel.

[Hack]

http://aspalliance.com/771

[MGunawan]

For ASP.NET there is no problem, my problem in winform application. this make me little confused, so i make function to Convert GridView to CSV file not to XLS. ... and everything ok.

Thanks for you help
-goen-

[Sonia]

http://aspalliance.com/771

Thank you

[ofergal]

I used the solution given in http://aspalliance.com/771
but it makes the use do save as *.XLS

A better solution is the one in http://www.codeproject.com/KB/office...etToExcel.aspx

[Rinia09]

http://p2p.wrox.com/c-2005/83080-con...methods-c.html
The post may be helpful for you!