CF - Spreadsheet download - dynamic

gistfile1.txt

<cfset q = queryNew("Name,Date", "varchar,date")>
<cfloop index="x" from="1" to="10">
    <cfset queryAddRow(q)>
    <cfset querySetCell(q, "Name", "Name #x#")>
    <cfset querySetCell(q, "Date", "4/4/22")>
</cfloop>
<cfdump var="#q#" abort>
<!--- <cfset dfStyle = {dataformat = "m/d/yy"}>--->

<cfset o = spreadsheetNew('dateTest', true)>
<cfset spreadsheetAddRows(o, q)>
<!--- <cfset spreadsheetFormatColumn(o, dfStyle, 2)>--->

<cfset bin = spreadsheetReadBinary(o)>

<cfheader name="Content-Disposition" value="attachment; filename=dateTest_#dateFormat(now(), 'ddmmmyyyy')#.xlsx">
<cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" variable="#bin#" reset="true">