Click here to Skip to main content
15,887,135 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello friends, we are trying to write our Htmltable to excel it is working fine, now actually we want to write data in 2 different sheet of the same excel. like there is Sheet1 and sheet2 in that we want to write 2 html table can any one help to do this. we are using htmlwriter to write data to excel. we are working in Sharepoint 2010 and we have created one asp.net page

C#
Response.Clear();
           Response.ContentType = "application/ms-excel";
           Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", filename));
           System.IO.StringWriter sw = new System.IO.StringWriter();
           HtmlTextWriter hw = new HtmlTextWriter(sw);
           tb.RenderControl(hw);
           Response.Write(sw.ToString());
           Response.End();
Posted
Updated 27-Nov-14 21:04pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900