how to create a excel/csv file on the fly?
Posted on 2004-03-31
Hello, I did my search around here and find Shooksm's code.
<cfheader name="content-disposition" value="attachment;filename=#Left(CreateUUID(), 8)#.html">
<title>Your Custom Query</title>
<table border="1" width="100%"><cfloop index="i" from="0" to="95" step="5">
But after I copied and pasted into a blank cfm file, when I call it from browser. it returns the table in the browser though I was expecting a download box pop up?
I am using CF4.5 by the way, could that be the reason?
Also it seems the <cfsavecontent> is introduced in 5.0. What should I do to get the equvilent?
I am trying to develop a page to show a table report and if clients want, they can click a button/link to download it into excel. I hope there is a way I don't need to write the report twice.