ooodev.adapter.table.cell_range_partial module

class ooodev.adapter.table.cell_range_partial.CellRangePartial(component, interface=com.sun.star.table.XCellRange)[source]

Bases: object

Partial Class for XCellRange.

Parameters:
  • component (XCellRange) –

  • interface (UnoInterface | None) –

__init__(component, interface=com.sun.star.table.XCellRange)[source]

Constructor

Parameters:
  • component (XCellRange) – UNO Component that implements com.sun.star.table.XCellRange interface.

  • interface (UnoInterface, optional) – The interface to be validated. Defaults to XCellRange.

Return type:

None

get_cell_by_position(col, row)[source]

Returns a single cell within the range.

Raises:

com.sun.star.lang.IndexOutOfBoundsExceptionIndexOutOfBoundsException

Return type:

XCell

Parameters:
  • col (int) –

  • row (int) –

get_cell_range_by_name(rng)[source]

Returns a sub-range of cells within the range.

The sub-range is specified by its name. The format of the range name is dependent of the context of the table. In spreadsheets valid names may be A1:C5 or $B$2 or even defined names for cell ranges such as MySpecialCell.

Return type:

XCellRange

Parameters:

rng (str) –

get_cell_range_by_position(left, top, right, bottom)[source]

Returns a sub-range of cells within the range.

Raises:

com.sun.star.lang.IndexOutOfBoundsExceptionIndexOutOfBoundsException

Return type:

XCellRange

Parameters:
  • left (int) –

  • top (int) –

  • right (int) –

  • bottom (int) –