IsSpreadsheetObject

Description

Returns a value that determines if the input is a spreadsheet object.

Returns

A Boolean value. True if the input is a spreadsheet object; False if it is a spreadsheet file.

Category

Microsoft Office Integration

Function syntax

IsSpreadsheetFile(spreadsheetobject)

See also

History

ColdFusion 9: Added.

Parameters

Parameter

Description

spreadsheeobject

Specifies the spreadsheet object.

Example

<cfspreadsheet action="read" src="C:/documents/SingleSheet.xls" name="SpreadsheetObj" > 
<cfoutput># isSpreadSheetObject(SpreadsheetObj)# an Object<br></cfoutput> 
<cfoutput># isSpreadSheetFile(SpreadsheetObj)# NOT a File<br></cfoutput>