Railo 4.2 Reference
Choose a function:

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