1 Reply Latest reply on Dec 4, 2006 10:36 AM by mikeap

    Query 2 Excel

    Level 7
      Anyone know where I can find a good Query 2 Excel UDF that allows me to
      specify a query and what column headers to export into either a CSV or an

      Seems like all the ones I find are confusing or don't allow me to specify
      the column headers on the outputed excel document.

        • 1. Re: Query 2 Excel
          mikeap Level 1
          I've attached my code that exports a query to an XLS.

          Basically you set it up with

          <cfcontent type="application/msexcel">
          <cfheader name="Content-Disposition" value="inline; filename=All_Leads.xls" charset="utf-8">

          Then build your table in HTML and whatever is there, is how it will be in XLS.