export html file to excel using asp.net

Question

Can anybody help me I am a beginner and have no concept how the conversion can be made.

Here is my code:

Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
Response.ContentEncoding = System.Text.Encoding.Unicode;
fuFile.RenderControl(hw);
Response.Output.Write(sw.ToString().Replace("&amp;nbsp;", "").Replace("&amp;", "&"));
Response.End();

Is this not enough to export an HTML file to Excel?

It looks like you're trying to upload a file (fuFile), and render its contents back to the user in Excel format? If that's true, update your question with what you are attempting to do and we can guide you to a workable solution. — Garrison Neely
– Garrison Neely, Commented Sep 17, 2013 at 15:53
i am trying to let the user upload a html file and then convert it into Excel file on button click event. — user2764839
– user2764839, Commented Sep 18, 2013 at 15:28

Community · Accepted Answer · 2017-05-23 12:05:04Z

2

I have found this works:

String content = "<html><body><table><tr><td>your table</td></tr></table></body></html>";

Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
Response.ContentType = "application/vnd.xls";
Response.Cache.SetCacheability(HttpCacheability.NoCache); // not necessarily required
Response.Charset = "";
Response.Output.Write(content);
Response.End();

As long as your content is well-formed HTML, this should work. Also note that comments, VBA code/macros, and multiple work-sheets do not work with this method. Additionally any styling that is not inline will also not render.

And some other considerations on this matter:
How can I export tables to excel from a webpage
http://www.c-sharpcorner.com/UploadFile/ankurmalik123/export-html-to-excel-and-more/

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Nov 19, 2013 at 19:04

devjc

11110 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

export html file to excel using asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related