Returns the data type of a cell: BLANK, BOOLEAN, ERROR, FORMULA, NUMERIC or STRING.
spreadsheetGetCellType(spreadsheet, row, column)
→ returns string
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.