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>

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub