Export dynamic query to excel

[biene22]

Hello,

I want to export a dynamic query result via button to excel.
I have a search template from where the users want to export the query results by clicking a button to an excel file.
Is it possible?

[Dan_Bracuk]

Make the query a session variable. When the user clicks the button, take them to another page where you can use cfheader and cfcontent to export to excel.

[biene22 · Accepted solution]

Hello Dan,

yes, query as session variable works fine. Thank you for help!

[Prasanth_Kumar_S]

Hi,
Try adding the header

<CFHEADER NAME="Content-Disposition" VALUE="attachment; FILENAME=resultFiles.xls">
<CFCONTENT TYPE="application/vnd.msexcel">

to the file and try. This will open the output file as an Excel document.

- Prasanth

[JR__Bob__Dobbs-qSBHQ2]

Here is a list of options.
http://www.carehart.org/resourcelists/tools_to_consider/index.cfm#excel