Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export to Excel 2
- Thread starter TSO456
- Start date
-
2
- #2
This worked fine for me.
<CFFILE contentType="application/x-msexcel"
action="write"
file="C:\inetpub\output =
'
<table border=1>
<td><b>Phone</b></td>
</tr></table>
'>
<!---Append to the existing file, pour data in corresponding headers---
<cfloop query="getPHONE">
<CFFILE
contentType="application/x-msexcel"
action="append"
file="c:\inetpub\output =
'
<table border=1>
<tr><td>#QUERY_NAME.phone#</td></tr><TAble>
'></cfloop>
<cfif SOME CONDITION>
<CFOUTPUT>
<cfheader name="Content-Disposition" value="download; filename=ExcelReport">
<cfcontent type="application/msexcel" file="File.xls" deletefile="no">
</CFOUTPUT>
</cfif>
<CFFILE contentType="application/x-msexcel"
action="write"
file="C:\inetpub\output =
'
<table border=1>
<td><b>Phone</b></td>
</tr></table>
'>
<!---Append to the existing file, pour data in corresponding headers---
<cfloop query="getPHONE">
<CFFILE
contentType="application/x-msexcel"
action="append"
file="c:\inetpub\output =
'
<table border=1>
<tr><td>#QUERY_NAME.phone#</td></tr><TAble>
'></cfloop>
<cfif SOME CONDITION>
<CFOUTPUT>
<cfheader name="Content-Disposition" value="download; filename=ExcelReport">
<cfcontent type="application/msexcel" file="File.xls" deletefile="no">
</CFOUTPUT>
</cfif>
- Thread starter
- #3
- Status
Similar threads
