getCellType

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 3 revisions

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"