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 |