cfdocs

spreadsheetRead

Create a new spreadsheet variable from specified file

spreadsheetRead(fileName, spreadsheetObj)
returns void

Argument Reference

Name Type Required Default Description
fileName string Yes   Path to spreadsheet file
spreadsheetObj variableName Yes   Spreadsheet name or number

Script Example

<cfscript> 
 a = SpreadSheetRead('C:\Files\Report.xls',"Annual Report") 
 </cfscript>