CF query save as xls file

Report · Sep 01, 2006

I have a little problem and I hopw anybody could help me.

I have a normal select statement and I want to run the select and have a SAVE AS button directly on the site to save a XLS file?

Please help me ASAP!

Report · Sep 01, 2006

The code below should get you started. Place it immediately after the <BODY> tag on your page. Place <CFOUTPUT> before your <TABLE> tag, and </CFOUTPUT> after your </TABLE> tag.

Within your table, each <TR> creates a new spreadsheet row and each <TD> creates a spreadsheet cell. You may have to do a File > Save As from your browser menu to save it as a Excel spreadsheet.

Adobe Community

CF query save as xls file