Writing to Excel

[Michael White]

HI All..

I have an asp page that queries a database and displays a report. There is a
button on this page that I would like to dump the report into Excel. The
code behind the button:

var xl = window.open("/reportexport.asp", "_blank");

and a new window is displayed with excel. Now the problem is how do I get
the report html into this new window?
xl.document.write(window.document.body.innerHTML); is obviously not the way
since it doesn't work.

reportexport.asp contains only two lines:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "filename=report.xls;"

Any help will be appreciated..

Thanks

 

[Bullschmidt]

Creating a Dynamic Report using ASP and Excel by Jeff Anderson -
1/9/2003
http://www.codetoad.com/asp_excel.asp

Output To MSExcel
http://www.codeave.com/asp/code.asp?u_log=40

ASP Tutorial: Dynamic Excel Reports
http://www.aspalliance.com/stevesmith/articles/exceltutorial.asp

VBScript and Excel
http://www.greggriffiths.org/webdev/both/excel/

HOWTO: Extract Information from Excel Sheet with DAO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;190195

Updating Excel From the Web by Bill Jeffries - 10/21/1999
http://www.15seconds.com/issue/991021.htm

Using Excel Spreadsheets as Web Data Sources by Steven B. Raines
http://algonquinstudios.com/articles/excel_db.asp

Help: Inserting into Excel with ADO
Andres - 6/13/2001 1:35:38 PM
http://www.aspmessageboard.com/forum/databases.asp?M=233741&P=1&F=21

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...