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
Required

No Help Available

data
Required

No Help Available

startrow
Required

No Help Available

startcolumn
Required

No Help Available

insert
Required

No Help Available

insert

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