1 Reply Latest reply on Sep 1, 2006 6:40 AM by jdeline

    CF query save as xls file

    npa2006
      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!
        • 1. Re: CF query save as xls file
          jdeline Level 1
          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.