Export HTML Table to Excel using ASP.NET

by

You want Export HTML table (Not Gridview) customized structure and data to Excel using ASP.NET.

Try the following Approach

  1. Provide the ID and add runat="server" attribute

    <table id="tbl" runat="server" >

  2. Add the following code

    Response.ContentType = "application/x-msexcel"; 
Response.AddHeader("Content-Disposition", "attachment;
filename=ExcelFile.xls");
Response.ContentEncoding = Encoding.UTF8; 
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
tbl.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();

More Related Contents:

  1. How to hide columns in HTML table?
  2. Frozen table header inside scrollable div
  3. Form inside a table
  4. Table fixed header and scrollable body
  5. Create HTML Table with SQL FOR XML
  6. How to deal with page breaks when printing a large HTML table
  7. Make a div fill the height of the remaining screen space
  8. Add border-bottom to table row
  9. How to remove unwanted space between rows and columns in table?
  10. How to make Scrollable Table with fixed headers using CSS [duplicate]
  11. How to make HTML table cell editable?
  12. How can I set the max-width of a table cell using percentages?
  13. How can I truncate table cells, but fit as much as content possible?
  14. Setting table column width
  15. How to force table cell content to wrap?
  16. Table scroll with HTML and CSS [duplicate]
  17. How to center the contents of an HTML table?
  18. How to hide Table Row Overflow?
  19. Min-width and max-height for table attributes
  20. Linethrough/strikethrough a whole HTML table row
  21. Why is box-sizing acting different on table vs div?
  22. into a : is it correct?
  23. Border around tr element doesn’t show?
  24. How to completely remove borders from HTML table
  25. with fixed and scrollable [duplicate]
  26. CSS: display:block; vs display:table;
  27. How do I export multiple html tables to excel?
  28. html tables: thead vs th
  29. Setting max-height for table cell contents
  30. Table vertical header?

Leave a Comment