spreadsheetAddColumn

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

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

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

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

Fork me on GitHub