export data into Excel

hi,

i made query , displayed data <cfgrid>. want make button on page open content/data in excel. [export excel]. possible in coldfusion? have started?

i tried example this:

<cfquery name="" datasource="">
select * dev
</cfquery>

<cfreport format="excel" template="test.xls"
query="#excel#" />

however doesn't work. see little symbol in left corner of opened window [square, triangle, ball on it].

could direct me in way?

regards,

kabbi

hi kabbi,

from point of view can create page same query in , output query result in page in <table> format. , @ end of page use following code. lik file through button click, should give popup open/save command.

<cfheader name="content-type" value="application/msexcel">
<cfheader name="content-disposition" value="attachment; filename=test.xls">

hope helps.

cheers / manu.

More discussions in Advanced Techniques

adobe