Hi,
Normally, I use the following to create an excel file
<cfcontent type="application/msexcel">
<cfheader name="Content-Disposition"
value="filename=myfilename.xls">
I have a multi-select combo box (e.g. employees)
Each employee has his own set of details and each employee's
details need to be on 1 separate excel file.
If I choose 1 employee at a time, it works fine.
But if I include the cfcontent and cfheader tags inside the
cfloop tag as follows, it doesn't work.
<!--- Loop each employee selected --->
<cfloop index="i" list="#form.employee_cb#"
delimiters=",">
<!--- create excel file --->
<cfcontent type="application/msexcel">
<!--- Create 1 file for each employee; each file
corresponds to each employee name --->
<cfheader name="Content-Disposition"
value="filename=#i#.xls">
<!--- Process each employee selected and output in excel
--->
</cfloop>
How can I generate 1 excel file automatically for each of the
employees?
Thanks and regards,
Yogesh Mahadnac