Exporting to Excel with ColdFusion

1
Exporting to Excel with ColdFusion

• By Rick Mason, SeedChoices.com

2
In five easy steps..
3
First link from the calling page

• ltA HREF"rpt_ViewCustExcel.cfm"
  TARGET"rpt_ViewCustExcel"gt
• ltbgtEXCELlt/bgtlt/Agt

4
Second build the query

• ltCFQUERY NAME"FetchCustomerExcel"
  DATASOURCE"S.db_Datasource"gt
• SELECT Customers.FName, Customers.LName,
  Customers.Address, Customers.City,
  Customers.State
• FROM Customers
• ORDER BY Customers.LName, Customers.FName
• lt/cfquerygt

5
Third call Excel using cfcontent

• ltcfcontent type"application/vnd.ms-excel"gt

6
Fourth create the headers

• ltcfoutputgt
• First_namechr(9)
• Last_namechr(9)Addresschr(9)
• Citychr(9)Statechr(13)
• lt/cfoutputgt

7
Fifth send the data

• ltcfoutput query"FetchCustomerExcel"gt
• fnamechr(9)lnamechr(9)
• Addresschr(9)Citychr(9)State
• chr(13)
• lt/cfoutputgt

8
(No Transcript)