Note:

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:

  1. Log in with your Gmail or Facebook credentials.
  2. Navigate to the project in the left pane.
  3. Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
  4. 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

SpreadsheetWriteSpreadsheetAddColumnSpreadsheetAddImageSpreadsheetAddRowSpreadsheetDeleteRow

SpreadsheetDeleteRowsSpreadsheetFormatRowSpreadsheetFormatRowsSpreadsheetShiftRows

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>

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy