MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 832 / 860

832 Chapter 37: Managing Files on the Server
To create an Excel spreadsheet with cfcontent:
1
Create a ColdFusion page with the following content:
<!--- use cfsetting to block output of HTML
outside of cfoutput tags --->
<cfsetting enablecfoutputonly="Yes">
<!--- get employee info --->
<cfquery name="GetEmps" datasource="CompanyInfo">
SELECT * FROM Employees
</cfquery>
<!--- set vars for special chars --->
<cfset TabChar = Chr(9)>
<cfset NewLine = Chr(13) & Chr(10)>
<!--- set content type to invoke Excel --->
<cfcontent type="application/msexcel">
<!--- suggest default name for XLS file --->
<!--- use "Content-Disposition" in cfheader for
Internet Explorer --->
<cfheader name="Content-Disposition" value="filename=Employees.xls">
<!--- output data using cfloop & cfoutput --->
<cfloop query="GetEmps">
<cfoutput>#Employee_ID##TabChar##LastName#
#TabChar##FirstName##TabChar##Salary##NewLine#</cfoutput>
</cfloop>
2
Save the file as employees_to_excel.cfm in the myapps directory under your web_root and view
it in the browser.
The data appears in an Excel spreadsheet: