You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.
Click the button below to launch CFFiddle.
To copy the project in your workspace in CFFiddle, follow the steps below:
- Log in with your Gmail or Facebook credentials.
- Navigate to the project in the left pane.
- Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
- Give the project a suitable name and click Save.
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, Other Spreadsheet functions.
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> |
Sign in to your account