G
Guest
I am pasting sample code below which I call on a button click. My problem is
that 6/7 is shown by excel as 7-Jun. I want it to look as 6/7 in excel.
Please let me know if anyone has a solution.
Thanks
string temp = "<html><table><tr><td>6/7</label></td></tr></table></html>";
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls");
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "";
EnableViewState = false;
Response.Write(temp);
that 6/7 is shown by excel as 7-Jun. I want it to look as 6/7 in excel.
Please let me know if anyone has a solution.
Thanks
string temp = "<html><table><tr><td>6/7</label></td></tr></table></html>";
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls");
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "";
EnableViewState = false;
Response.Write(temp);