Lucee Function Reference
Function 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 |