dont need to put # on the name, more likely it will cause an error, what I think might be your issue is you havent set the sheet as active before trying to put any information on it, try like this...

<cfscript>

///We need an absolute path, so get the current directory path.

theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "newSpreadsheet.xls";

//Create a new Excel spreadsheet object.

theSheet = SpreadsheetNew("Expenses");

SpreadSheetSetActiveSheet(theSheet, "Expenses");

SpreadSheetAddRow(theSheet,"Order,First Name,Last Name,Address,Amount,City");

SpreadSheetAddRow(theSheet,"Order,First Name,Last Name,Address,Amount,City");

SpreadSheetAddRow(theSheet,"Order,First Name,Last Name,Address,Amount,City");

</cfscript>

<!--- Write the spreadsheet to a file, replacing any existing file. --->

<cfspreadsheet action="write" filename="#theFile#" name="theSheet" overwrite=true sheetname = "Expenses">

You forgot to put hashtags around the variable name that is the Spreadsheet object "theSheet" should be "#theSheet#".

HTH,

^ _ ^

I don't see where you are including the Spreadsheet object for the write.

V/r,

^ _ ^