Class CellValues

class ooodev.utils.data_type.cell_values.CellValues(col, row, sheet_idx=-1)[source]

Cell Parts

New in version 0.8.2.

Parameters:

  • col (int) –

  • row (int) –

  • sheet_idx (int) –

__init__(col, row, sheet_idx=-1)
Parameters:

  • col (int) –

  • row (int) –

  • sheet_idx (int) –

Return type:

None

static from_cell(cell_val)[source]

Gets cell values

Parameters:

cell_val (str | CellAddress | mCellObj.CellObj | CellValues) – Cell value. If cell_val is CellValues instance then that instance is returned.

Returns:

Cell values representing cell_val

Return type:

CellValues

get_cell_address()[source]

Gets a cell address

Raises:

ValueError – If sheet_idx is a negative value.

Returns:

Cell Address

Return type:

CellAddress

col: int

Column such as 1. Must be non-negative integer value.

row: int

Row such as 125. Must be non-negative integer value.

sheet_idx: int = -1

Sheet index that this cell value belongs to. -1 means no sheet is defined for this instance. -2 means no sheet is defined for this instance and not attempt to get the sheet should be made.