spreadsheetAddColumn

Adds a column or column data to an Excel spreadsheet object.

spreadsheetAddColumn(spreadsheetObj, data, startrow, startcolumn, insert [, insert]) → returns void

spreadsheetAddColumn Argument Reference

spreadsheetObj Variablename
Required

No Help Available

data String
Required

No Help Available

startrow Numeric
Required

No Help Available

startcolumn Numeric
Required

No Help Available

insert Boolean
Required

No Help Available

insert boolean

No Help Available

Examples sample code invoking the spreadsheetAddColumn function


Tag Example

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

Fork me on GitHub