>Should also point out that Office or Excel will have to be installed on the >clients computer for this to work as well. > >-- >Regards, >Andrew Scott >WebSite: http://www.andyscott.id.au/ >Google+: http://plus.google.com/108193156965451149543 > > > > >Try using: ><cfcontent type="application/msexcel"> ><cfheader name="Content-Disposition" value="fileName.xls">
Hi Andrew , I've tested the below code and it works well...The only thing i want to add is to call it on button click . Thoughts ? <cfquery name="queryData" datasource="#DNS1#"> SELECT * FROM TABLE1 </cfquery> <body> <cfheader name="Content-Disposition" value="inline; filename=Employee_Report.xls"> <cfcontent type="application/vnd.ms-excel"> <table border="2"> <tr> <td> ID </td><td> Name </td> </tr> <cfoutput query="queryData"> <tr> <td>#ID#</td><td>#EMP_NAME#</td> </tr> </cfoutput> </table> </cfcontent> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5586 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
