Click here to Skip to main content
15,905,867 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i am having one string html table i want it to export to excel can it possible or not?

if not then give me a solution where i can export to excel can work at client side not at server


XML
HtmlTable.AppendLine("<table id='tblResult' cellpadding='3' cellspacing='1' border='0' >");
           HtmlTable.AppendLine("<tr>");


           for (int i = 0; i < datatable.Rows.Count; i++)
           {
               HtmlTable.AppendLine("<td>" + datatable.Rows[i][xAxisField].ToString() + "</td><td>" + datatable.Rows[i][yAxisField].ToString() + "</td>");

           }
           HtmlTable.AppendLine("</tr>");
           HtmlTable.AppendLine("<table>");

var table=some code of above result
Posted

1 solution

short in time, so just a thougth, intopt is bad idea for your client needs excel installed, ace 12 has ha export feature for exporting sql to excel an it's latest version(64 bit) is available as free redist package. hans.
 
Share this answer
 

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