In order to create an Excel report dynamically, I am simply using below piece of code

 

Response.AddHeader("Content-Disposition","attachment;filename = " + strOutPutFileName + ".xls");                              

Response.ContentType= "application/ms-excel";

Response.ContentEncoding=Encoding.UTF7;

 
Here I am facing formatting problem. I'm populating a cell with a character string, but if that string (i.e. 000123) is to be numeric, then it displays 123. Result should be 000123. How can I solve this problem?
 
Thanks and Regards,
Asheesh



  





YAHOO! GROUPS LINKS




Reply via email to