Export data to CSV from ColdFusion

export2csv.cfm

	<!--- Read data from two datasource tables. ---> 
<cfquery 
       name="iae1" datasource="escolar_db13"> 
       select * from v_rc_iae_pr1
</cfquery> 
<cfscript> 
    //Use an absolute path for the files. ---> 
       theDir=GetDirectoryFromPath(GetCurrentTemplatePath()); 
       theFile=theDir & "exportData.xls"; 
    //Create two empty ColdFusion spreadsheet objects. ---> 
		theSheet = SpreadsheetNew("DATOS REGIONAL"); 

    //Populate each object with a query. ---> 
    SpreadsheetAddRows(theSheet,iae1); 

</cfscript> 
<cfspreadsheet action="write" filename="#theFile#" name="theSheet"  
    sheetname="iae1" overwrite=true> 
<cfspreadsheet action="read" src="#theFile#" sheet=1 format="csv" name="csvData"> 

<cfspreadsheet action="write" filename="#theFile#" name="CSVData"  
    format="csv" sheetname="iae1" overwrite=true>
<a href="exportData.xls">Descargar</a>