Generate Excel file with multiple worksheets using ASP
View Single Post
07-15-2011, 08:37 PM
New to the CF scene
Join Date: Jul 2011
Thanked 0 Times in 0 Posts
Originally Posted by
If you save a multi-worksheet Excel workbook as a web page (.htm) then you will end up with more than one file. If you were to to do that in ASP then you would have to create the supporting files and reference them in the main page.
If your target audience are using Excel 2003 or 2007 then you have some more options.
A fairly simple one is to output your multi-worksheet workbook as XML. Microsoft have documented this somewhere (probably on MSDN) but I often find it easier to create a mockup of the results file in Excel and save it as XML to see what is required.
Here is a fairly simple example:
the code is here
Thank you very much for this. I have been searching the web for 8 hours and final found this post. It solved all my nightmares
thanks once again. Keep up the good help
View Public Profile
Find More Posts by do_while