spreadsheetGetCellType

ColdFusion

Open app

Description

Retrieves the data type of a specified cell in a spreadsheet.

Returns

A string with one of the following values- BLANK, BOOLEAN, ERROR, FORMULA, NUMERIC, or STRING.

History

ColdFusion (2025 release): Added the function.

Syntax

spreadsheetGetCellType(spreadsheetObject,row,column)

spreadsheetGetCellType(spreadsheetObject,row,column)

Parameters

Name

Required

Type

Description

spreadSheetObject

Yes

ExcelInfo

The Excel spreadsheet object for which to get the cell type.

row

Yes

Integer

The row number of the cell.

column

Yes

Integer

The column number of the cell.

Example

SELECT * FROM ART

</cfquery>

theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls";

// create a spreadsheet object

theSheet=spreadsheetNew("SampleData")

// add rows from query

spreadsheetAddRows(theSheet,art)

// writeOutput(theFile)

spreadsheetWrite(theSheet,theFile,"yes")

// get cell type

cellType=spreadsheetGetCellType(theSheet,1,4)

writeOutput(cellType)

</cfscript>

<cfquery name="art" datasource="art"> SELECT * FROM ART </cfquery> <cfscript> theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls"; // create a spreadsheet object theSheet=spreadsheetNew("SampleData") // add rows from query spreadsheetAddRows(theSheet,art) // writeOutput(theFile) spreadsheetWrite(theSheet,theFile,"yes") // get cell type cellType=spreadsheetGetCellType(theSheet,1,4) writeOutput(cellType) </cfscript>

<cfquery name="art" datasource="art">
    SELECT * FROM ART
</cfquery>
<cfscript>
    theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls";
    // create a spreadsheet object
    theSheet=spreadsheetNew("SampleData")
    // add rows from query
    spreadsheetAddRows(theSheet,art)
   // writeOutput(theFile)
    spreadsheetWrite(theSheet,theFile,"yes")
    // get cell type
    cellType=spreadsheetGetCellType(theSheet,1,4)
    writeOutput(cellType)
</cfscript>

Output

STRING

The script adds rows from a query result into a spreadsheet. Then the spreadsheetGetCellType function retrieves the data type of the specified cell, referenced by row and column.

Get help faster and easier

New user?