spreadsheetAddRow

Adds a row to an Excel spreadsheet object.

spreadsheetAddRow(spreadsheetObj, data [, row] [, column] [, insert] [, datatype]) → returns void

Argument Reference for the spreadsheetAddRow function

spreadsheetObj

Required: Yes
The speadsheet

data

Required: Yes
A comma seperated list of cell values.

row

Required: No
Row number at which to insert, if omitted appended.

column

Required: No
Default: 1
Column number at which to insert data.

insert

Required: No
Default: true
When true appends data to spreadsheetObj, when false attempts to update rows.

datatype

Required: No
CF 11+ List of datatype expressions with values such as STRING NUMERIC or DATE. For example use `DATE:1;NUMERIC:2-2;STRING

Examples sample code invoking the spreadsheetAddRow function


Add a row to SpreadSheet

<!--- Make a new spreadsheet object --->
<cfset s = spreadsheetNew()>
<!--- Add header row --->
<cfset spreadsheetAddRow(s,"Name,Beers,Vegetables,Fruits,Meats")>
<cfdump var="#s#" />

Fork me on GitHub