binodtechversant

<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)>