bool = xlsx.HaveCellFormula(id, x, y[, sheet]) bool = xlsx.HaveCellFormula(id, ref[, sheet])
True
if the specified cell has a formula, otherwise
False
is returned. There are two ways of specifying
the cell you want to check: You can either specify the cell to use by
passing the cell's column (x) and row (y) position in the x
and y
arguments. Those
positions start from 1 for the first column and row. Alternatively, you
can also specify the cell by passing its reference in the ref
parameter. This can either
be a string, e.g. "A10" for the first cell in the 10th row, or an iterator state returned
by the xlsx.CellRange() function. Optionally, you can also pass the index of the worksheet to
use in the optional sheet
parameter (starting from 1 for the first worksheet). If
the sheet
parameter is omitted, the worksheet set by xlsx.SetDefaultSheet()
will be used.
x
and y
are omittedTrue
if the cell has a formula, False
otherwise