Export Asp.net Table to Excel

Question

hello,

i am developing a web application. Can someone help me with code to export data in an asp.net table to excel or csv format.

thanks in anticipation.

Answer 1

Hi Tryxo

   Welcome to Microsoft Office for Developers forum! I'm glad to see your active participation and discussion in Microsoft Office for Developers forum. Here's a same issue with yours has been solved please refer to below link:

    (How to transfer html table data into excel sheet?) http://forums.asp.net/t/1214938.aspx

  Hope these will help you!  

   If you still have any doubt and concern about this issue, please let me know. If I misunderstood you, please kindly elaborate your question.

---

Please Mark as Answered If this is helpful Or Un-Mark as Answered if it is not helpful.

Best Regards,
Yan Jun
Microsoft Online Community Support

Answer 2

thank you, Yan Jun. it worked! i'm glad i have finally solved this problem; i've been on it for days.

thanks alot.

one more thing: is it possible for me to sort the data on the table by one of the columns before displaying it on the web page. its actually an asp table not html.

pls assist me if u can.

Answer 3

Hi,

I have written a code to export datatable into excel without using any third party tool. please look at it.

http://aspnet-ajax-aspnetmvc.blogspot.com/2011/06/export-datatable-to-excel-with-special.html

 

Thanks,

Mohan Prajapati

http://aspnet-ajax-aspnetmvc.blogspot.com/

Answer 4

for exporting asp.net table to excel, free solution to export data to EXCEL, WORD, PDF WITHOUT OLE AUTOMATION.
http://www.codeproject.com/Tips/190144/Export-Database-to-Excel-PDF-HTML-RTF-XML-etc-for