CFSpreadsheet and Data with Commas

This was driving me crazy the other day.  I needed to generate a spreadsheet and because of the way the data needed to be processed, I couldn’t just pass an entire query to the spreadsheet object.  However, one of the cells I needed to populate had data that included commas and that completely broke the spreadsheet.  I stumbled across this gem:

Basically, wrap the variable in single quotes and then in double quotes like this:

SpreadsheetAddRow ( mySheet,"'#mySingleColumnValue#'");