Lt,
One other thing that works beautifully is if you are good at HTML. Create a new page with just <HTML> and </HTML> Blocks. Then add the following line: <% Response.ContentType = "application/vnd.ms-excel"%> Then do <TABLE> 'anything you put in here into a cell using <TD> and <TR> will be converted to an .xls file when the page is finished rendering. For example: <TD>1</TD> <TD>1</TD> <TD>=A1+B1</TD> </TABLE> This would return an excel spreadsheet with: 1 1 2 I know this works with excel 2002 and 2003. Some issue with lower versions. This is not exactly as nice as the way the article shows it but it doesn't require adding any controls, its pretty straightforward. Does anyone know why there would be formatting issues with older versions of excel?? ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ltrane923 Sent: Sunday, October 16, 2005 8:39 PM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Exporting to a Preformatted Excel Spreadsheet from aspx page Hello: I need to find a tutorial or code example (that works!)that I can use which shows how to post a data from an aspx page to a preformatted Excel style sheet. I found this one http://www.aspnetpro.com/newsletterarticle/2003/09/asp200309so_l/asp2003 09so_l.asp but started getting errors on it his first example. There is also a half baked one at Builder.com which was of no help. Thanks LT SPONSORED LINKS Basic programming language <http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Basic +programming+language&w2=Computer+programming+languages&w3=Programming+l anguages&w4=Java+programming+language&c=4&s=126&.sig=bnac3LCZpttb3c9FvbV U-A> Computer programming languages <http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=B asic+programming+language&w2=Computer+programming+languages&w3=Programmi ng+languages&w4=Java+programming+language&c=4&s=126&.sig=1Czd2hKCO9_u4KV ZQperFQ> Programming languages <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Basic+prog ramming+language&w2=Computer+programming+languages&w3=Programming+langua ges&w4=Java+programming+language&c=4&s=126&.sig=TyHGCjod4YOKITrSq1xccQ> Java programming language <http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Basic+ programming+language&w2=Computer+programming+languages&w3=Programming+la nguages&w4=Java+programming+language&c=4&s=126&.sig=PZAexF9LyXpKb3HDJSlB 1g> ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspNetAnyQuestionIsOk <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] cribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
