2 Replies Latest reply on Nov 10, 2008 12:11 PM by Dan Bracuk

    Saving Generated Excel Files

    Magikaru
      Hi guys,

      I have a CF page that is generating an excel file from an html table. ex:

      <cfheader name="Content-Disposition" value="inline; filename=excel1.xls">
      <cfcontent type="application/vnd.msexcel">
      <table border="1" cellpadding="1" cellspacing="2">
      <tr>
      <th>Column 1</th>
      <th>Column 2</th>
      </tr>
      <tr>
      <td>Data1</td>
      <td>Data 2</td>
      </tr>
      </table>

      When the page is run, it presents the user with an excel file and asks if they would like to open it or save it. I was wondering if it's possible to save the excel file automatically. So, for instance, I could have scheduled tasks running that generated and saved an excel report without user input. Any idea on how this can be done? I assume it involves cffile in some way but I haven't been able to figure it out. Thanks!