CFSPREADSHEET
Read, write and update spreadsheet files
Usage
<cfspreadsheet>
Attributes
| Attribute | default | required | summary |
|---|---|---|---|
| ACTION=READ |  |
Reads a spreadsheet file into a spreadsheet object or query | |
| ACTION=WRITE | |
Writes data to a spreadsheet file | |
| ACTION=UPDATE | |
Updates an existing spreadsheet file | |
| SHEET | The Sheet number to be active (only SHEET or SHEETNAME must be present) | ||
| SHEETNAME | The Sheet name to be active (only SHEET or SHEETNAME must be present) | ||
| HEADERROW | The row in the spreadsheet that is to be considered the header for the query (only HEADERROW or COLUMNNAMES must be present) | ||
| COLUMNNAMES | The comma-separated names for the column names (only HEADERROW or COLUMNNAMES must be present) | ||
| SRC | The source for the file, expressed as full path | ||
| FORMAT | The format for the (csv,html) for the resulting object; if not present then NAME is the spreadsheet object | ||
| NAME | The name of the variable that will receive/extract the data | ||
| QUERY | The query variable that will receive/extract the data in CFML Query object | ||
| COLUMNS | all | The columns to be used in the format (1,2,3,5-6) | |
| ROWS | all | The rows to be used in the format (1,2,3,5-6) | |
| FILENAME | The filename to use when writing or updating | ||
| OVERWRITE | false | Boolean flag to overwrite the file |