I dont know about that but I had the problem using that approach that I could not get the toolbar at the top to show up to allow the user to save the .xls. Did you find a way around that? I ended up using the com object for the .xls.
--- In [email protected], "Asheesh S Parihar" <[EMAIL PROTECTED]> wrote: > > 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 > > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
