export data from uploaded htmlfile to excell using c#?

Question

Dear All how to export data from uploaded htmlfile to excell using asp.net? am giving screenshot please find it and give me some code in asp.net ? please its urgent

Vicky Bhatt · Answer

Hello Prasad, Yes i got your point. now check as below code which is converted html content to excel file. So just you have to do that your uploaded html file replace with html content. String HTMLContent = " your table "; Response.AppendHeader("content-disposition", "attachment;filename=ExportedHtml.xls"); Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.ms-excel"; this.EnableViewState = false; Response.Write(HTMLContent); Response.End(); If as above answer helpful to you than please accept my answer. Thanks, Vicky

Prasad Bhagat · Answer

Dear Vicky, Thanks for Reading my post,but the scenario Ur answer was current web page html tags was converting into excel .but my scenario is uploading a html file using file upload button and after converting that html file to excel. That is the deference. Thanks and Regards Prasad Bhagat

Vicky Bhatt · Answer

Hi Prasad, If you want to convert uploaded html file to excel, you could refer to the following sample link:- http://forums.asp.net/t/2079076.aspx?how+to+export+data+from+uploade+html+page+to+excell+using+asp+net+and+c+ as above link show candice zhou answer. This answer help for your question. If above link helpful to you than please accept my answer.

export data from uploaded htmlfile to excell using c#?

Answers (3)