SpreadsheetRead

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

SpreadsheetWriteSpreadsheetAddColumnSpreadsheetAddImageSpreadsheetAddRowSpreadsheetDeleteRowSpreadsheetDeleteRowsSpreadsheetFormatRowSpreadsheetFormatRowsSpreadsheetShiftRows, 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>
Adobe logo

Sign in to your account