Lucee Function Reference
spreadsheetaddrows()
Example
spreadsheetaddrows(org.cfpoi.spreadsheet.Spreadsheet spreadsheet,query data,[numeric row,[numeric column,[boolean insert,[struct formats,[boolean autoSizeColumns]]]]]):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 | query | Yes | |
row | numeric | No | |
column | numeric | No | |
insert | boolean | No | |
formats | struct | No | |
autoSizeColumns | boolean | No |