create .xlsx file using cfspreadsheet with more than 200K records in CF 10

Use threads. Here is an example:

<cfscript>

thread action="run" name="createSheet" {

  filepath=expandpath(".") & "\" & "Orders.xlsx";

  // Get data from a query

  sql="SELECT orderid,customerfirstname,customerlastname,address,total,city FROM orders

  ORDER BY orderid";

  sqlParams={};

  artOrders=queryExecute(sql,sqlParams,{datasource="cfartgallery"});

  // Create a spreadsheet object with sheetname Art

  spreadsheetObj=spreadsheetNew("Art",true);

  // Add rows with data from query result. The data start from row 1, col 1.

  // The spreadsheet will have column names.

  spreadsheetAddrows(spreadsheetObj,ArtOrders,1,1,true,[""],true);

  dirName=GetDirectoryFromPath(GetCurrentTemplatePath());

  // Write spreadsheet to a file

  SpreadsheetWrite(spreadsheetObj,filepath,true);

}

thread action="run" name="downloadSheet" {

    filepath=expandpath(".") & "\" & "Orders.xlsx";

    cfheader(name="Content-Disposition", value="attachment; filename=Orders.xlsx");

    cfcontent(type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", file="#filepath#");

}

thread action="join" name="createSheet,downloadSheet";

</cfscript>