Exporting query data to Excel - best way?

[Aquitaine]

Hi there,

Something I've had to do a couple of times in the past but that I don't spend
enough time to be a real whiz at is taking a query result and dumping it to raw
text - CSV, tab-delimited, something like that. Historically, I manually wrote
out the new file in CF with the help of chr() and so forth. Needless to say,
'tedium' doesn't begin to describe this.

I now have a couple clients that want to do this more often, all of them using
Excel. In one case, they ultimately need the file in CSV format, but I'm
wondering: is there perhaps a much easier way of doing this? Dumping a CFQUERY
straight to XML and having Excel read that in? Some custom tag/CFC that does
this more smoothly than I have been doing it? What's your favorite
CFQuery-to-downloadable-file mechanism?

Thanks!
Samuel Knowlton
iamsam.org

[jdeline]

Use the code below as a starter kit.


<cfheader name="Content-Disposition" value="inline; filename=acmesalesQ1.xls">
<cfcontent type="application/vnd.msexcel">

<table border="2">
<tr><td>Month</td><td>Quantity</td><td>$ Sales</td></tr>
<tr><td>January</td><td>80</td><td >$245</td></tr>
<tr><td>February</td><td>100</td><td>$699</td></tr>
<tr><td>March</td><td>230</td><td >$2036</td></tr>
<tr><td>Total</td><td>=Sum(B2..B4)</td><td>=Sum(C2..C4)</td></tr>
</table>

[Aquitaine]

Aha! Wonderful. So simpe. Thank you!