Click here to Skip to main content
15,921,660 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 page

           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);
Updated 27-Nov-14 21:04pm

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