spreadsheetRead

Create a new spreadsheet variable from specified file

spreadsheetRead(fileName, spreadsheetObj) → returns void

  1. CFDocs
  2. Functions
  3. Spreadsheet Manipulation Functions
  4. spreadsheetRead
  5. CF
  6. BD
  7. 0 Issue
  8. Edit

Argument Reference

fileName string
Required

Path to spreadsheet file

spreadsheetObj variableName
Required

Spreadsheet name or number

Examples
Sample code invoking the spreadsheetRead function 

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