spreadsheetAddColumn

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

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

Argument Reference for the spreadsheetAddColumn function

spreadsheetObj

Required: Yes
No Help Available

data

Required: Yes
No Help Available

startrow

Required: Yes
No Help Available

startcolumn

Required: Yes
No Help Available

insert

Required: Yes
No Help Available

insert

Required: No
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