Description
Reads a sheet from a spreadsheet file and stores it in a ColdFusion spreadsheet object.
Returns
Returns spreadsheet object.
Category
Microsoft Office Integration
Function syntax
SpreadSheetRead(fileName [, sheetName|sheet]) |
See also
SpreadsheetWrite, SpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow,
SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows
History
ColdFusion 9: Added the function.
Parameters
Parameter |
Description |
|---|---|
fileName |
A string specifying the path to the spreadsheet file. |
sheetName |
Optional parameter; name of the sheet. You can specify sheet or sheetName. |
sheet |
Optional parameter; number of the sheet. You can specify sheet or sheetName. |
Usage
Use this function to read an Excel file with multiple sheets.
Example
| {{<cfscript> a = SpreadSheetRead("C:\Files\Report.xls","Annual Report") </cfscript>}} |
