cfspreadsheet
9

Overview ColdFusion Open BlueDragon Lucee

Manages Excel spreadsheet files:

Attributes

Name Required Type Default Description
9
action No String One of the following:• read - Reads the contents of an XLS format file.• update - Adds a new sheet to an existing XLS file. You cannot use the uppdateaction to change an existing sheet in a file. For more information, see Usage.• write - Writes a new XLS format file or overwrites an existing file.
11
autosize No Boolean true If false, all comuns of sheets will not be resized.
9
columnnames No String Comma-separated column names.
9
columns No String Column number or range of columns. Specify a single number, a hypen-separated column range, a comma-separated list, or any combination of these; for example: 1,3-6,9.
9
excludeheaderrow No Boolean If set to true, excludes the header row from being included in the query results.
9
filename No String The pathname of the file that is written.
9
format No String Format of the data represented by the name variable.
9
headerrow No Numeric Row number that contains column names.
9
name No String read action: The variable in which to store the spreadsheet file data. You must specify name or query.if format='csv' then name will contain csv variable.if format='html' then name will contain html content.write and update actions: A variable containing CSV-format data or an ColdFusion spreadsheet object containing the data to write. You must specify name or query.
9
overwrite No Boolean A Boolean value specifying whether to overwrite an existing file.
9
password No String Set a password for modifying the sheet.
9
query No String • read action: The query in which to store the converted spreadsheet file. You must specify format, name, or query.• write and update actions: A query variable containing the data to write. You must specify name or query.
9
rows No String The range of rows to read. Specify a single number, a hypen-separated row range, a comma-separated list, or any combination of these; for example: 1,3-6,9.
9
sheet No Numeric Number of the sheet.
9
sheetname No String Name of the sheet.
9
src No String The pathname of the file to read.