If you have ever wanted to export the results of a query displayed on your website into an excel spreadsheet, here is a simple way to do so. One of the key items to note in the following coding example is that you should not change the space in between fields in the CFSet, otherwise you risk the export not working.

I'm very interested in doing this.
You forgot to close quote at the end of #fieldc#.

Although this creates an xls file, it doesn't create three columns.

There is a free podcast at the cfUnited blog, and one is titled
"Jeremy Lund - Another Look at Microsoft Office Using Apache Jakarta POI", which is a method of working directly with Microsoft Office documents such as Word and Excel.

I don't know if HMS uses this feature, but it apparently comes with CF.

Extra notes:

Adding the following to the code will output the file as an xls, otherwise your browser will see the incoming file as the page name (ie page.cfm)



Also putting tabs between elements will instead of spaces will create new columns.

You don't even need to write a file to disk you can just set headers and then do your normal output of what you want:

<cfheader name="Content-Disposition" value="attachment; filename=#currentDisplayReport#.xls">
<cfcontent type="application/vnd.ms-excel">

You can then output data as an html table or for more customization use Microsoft's XML format.

Or just use the POI solution mentioned by the other poster.