StackOverflow - Q37418523

<!---
Test.xlsx contains two columns, with headers on row 1
- Column A format: *m/d/yyyy
- Column B format: number with 2 decimal places
--->
<cfset filename = "c:/path/to/Test.xlsx">
<cfspreadsheet  action="read" src = "#filename#"  name = "s" >
<cfset myQuery = QueryNew("MyDate,Dollar", "Date,Decimal")>

<cfset newRow = QueryAddRow(MyQuery, 5)>
<cfset QuerySetCell(myQuery, "MyDate", parseDateTime("2000-03-11", "yyyy-mm-dd"), 1)>
<cfset QuerySetCell(myQuery, "Dollar", "403.45", 1)>
<cfset QuerySetCell(myQuery, "MyDate", parseDateTime("2009-01-01", "yyyy-mm-dd"), 2)>
<cfset QuerySetCell(myQuery, "Dollar", "603.22", 2)>

<cfset QuerySetCell(myQuery, "MyDate", parseDateTime("2013-09-21", "yyyy-mm-dd"), 3)>
<cfset QuerySetCell(myQuery, "Dollar", "103.55", 3)>

<cfset QuerySetCell(myQuery, "MyDate", parseDateTime("2005-01-15", "yyyy-mm-dd"), 4)>
<cfset QuerySetCell(myQuery, "Dollar", "3.33", 4)>

<cfset QuerySetCell(myQuery, "MyDate", parseDateTime("2003-07-22", "yyyy-mm-dd"), 5)>
<cfset QuerySetCell(myQuery, "Dollar", "13.75", 5)>


<cfset spreadsheetAddRows(s, myQuery)>
<cfset spreadsheetFormatColumn(s, {dataFormat="m/d/yy"}, 1)>


<cfheader name="content-disposition" value="attachment; filename=Departures_(#DateFormat(now(),'mmddyy')#).xlsx">
<cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" variable="#spreadsheetReadBinary(s)#" reset="true">