spreadsheetGetCellType

Returns the data type of a cell: BLANK, BOOLEAN, ERROR, FORMULA, NUMERIC or STRING.

spreadsheetGetCellType(spreadsheet, row, column) → returns string

Argument Reference

spreadsheet any
Required

The spreadsheet object.

row numeric
Required

Row number (1-based).

column numeric
Required

Column number (1-based).

Compatibility

RustCFML:

Not supported on wasm32. Returns "undefined" for an empty cell. Member form: getCellType(row, column).

Examples
Sample code invoking the spreadsheetGetCellType function

Inspect the types of a value cell and an empty cell.

wb = Spreadsheet("xlsx");
spreadsheetSetCellValue(wb, 42, 1, 1);
writeDump(spreadsheetGetCellType(wb, 1, 1));
writeDump(spreadsheetGetCellType(wb, 5, 5));

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub