Lucee Function Reference
spreadsheetaddrow()
Example
spreadsheetaddrow(org.cfpoi.spreadsheet.Spreadsheet spreadsheet,string data,[numeric row,[numeric column,[boolean insert,[string delimiter,[boolean handleEmbeddedCommas]]]]]):void
Arguments
The arguments for this function are set. You can not use other arguments except the following ones.
Name | Type | Required | Description |
---|---|---|---|
spreadsheet | org.cfpoi.spreadsheet.Spreadsheet | Yes | |
data | string | Yes | Delimited list of values |
row | numeric | No | Target row number. If omitted, data is added to the next unpopulated row |
column | numeric | No | Target column number |
insert | boolean | No | If true, data is inserted as a new row. Otherwise, existing data is overwritten |
delimiter | string | No | Delimiter for the list of values. (Default is a comma) |
handleEmbeddedCommas | boolean | No | When true, values enclosed in single quotes are treated as a single element like in ACF. Only applies when the delimiter is a comma. |