getCellType - cfsimplicity/spreadsheet-cfml GitHub Wiki

Gets the Excel data type of a cell in the active sheet. Returns a string containing one of the following:

• BLANK
• BOOLEAN
• ERROR
• FORMULA
• NUMERIC
• STRING

(NOTE: Dates are stored as NUMERIC in Excel.)

getCellType( workbook, row, column )

Required arguments

• workbook spreadsheet object
• row numeric
• column numeric

Chainable? Yes but ends the chain.

Example

spreadsheet = New spreadsheet();
spreadsheet.setCellValue( workbook, "test", 1, 1 );
celltype = spreadsheet.getCellType( workbook, 1, 1 );// returns "STRING"