Create a new spreadsheet variable from specified file
spreadsheetRead(fileName, spreadsheetObj)
returns void
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
| fileName | string | Yes | Path to spreadsheet file | |
| spreadsheetObj | variableName | Yes | Spreadsheet name or number |
<cfscript>
a = SpreadSheetRead('C:\Files\Report.xls',"Annual Report")
</cfscript>