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>