Last updated on
Feb 25, 2025
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)
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
<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.
