Exporting Queried Data to Excel

Hello,
I would like to export a queried dataset to excel using a button. So far my research yielded an option that migrates to a different page. Any thoughts?

Thanks,
Joe

 

Are you using cfheader & cfcontent?

<cfheader name="Content-Disposition" value="filename=foo.xls">

<cfcontent type="application/msexcel">

 

I use both the cfheader and cfcontent. I managed to manipulate the output alright, I'm just curious how to incorporate that code into a button. Any thoughts? Thanks for your help so far.

 

<input type='button' value='Export to Excel' onclick="document.location.href='prepareEXcel.cfm'>

PrepareExcel.cfm
Carry out functions to create the file - then follow IsRoss()'s example

Good Job IsRoss()

 

Thanks for your help guys.