Adds a column or column data to an Excel spreadsheet object.
spreadsheetAddColumn(spreadsheetObj, data, startrow, startcolumn, insert [, insert])
→ returns void
<cfscript>
mySheet = SpreadsheetNew( "Test" );
writeDump( mySheet );
SpreadsheetAddColumn( mySheet, "MySingleColumn" ); // Add a row of data: a single value for the single column
mySingleColumnValue = "As you can see, this sentence contains commas, which force the value to be split over 3 columns instead of one.";
SpreadsheetAddRow( mySheet, mySingleColumnValue );
writeDump( mySheet );
</cfscript>Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.