Query 2 Excel

[Newsgroup_User]

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
XLS.

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

[mikeap]

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.