ooodev.adapter.sheet.cell_range_data_partial module

class ooodev.adapter.sheet.cell_range_data_partial.CellRangeDataPartial(component, interface=com.sun.star.sheet.XCellRangeData)

Bases: object

Partial Class for XCellRangeData.

New in version 0.32.0.

Parameters:

• component (XCellRangeData) –

• interface (UnoInterface | None) –

__init__(component, interface=com.sun.star.sheet.XCellRangeData)

Constructor

Parameters:

• component (XCellRangeData) – UNO Component that implements com.sun.star.sheet.XCellRangeData.

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

Return type:

None

get_data_array()

Gets an array from the contents of the cell range.

Each element of the result contains a float or a string.

Return type:

Tuple[Tuple[Any, ...], ...]

set_data_array(array)

Fills the cell range with values from an array.

The size of the array must be the same as the size of the cell range. Each element of the array must contain a float or a string.

Warning

The size of the array must be the same as the size of the cell range. This means when setting table data the table must be the same size as the data. When setting a table range the array must be the same size as the range.

Return type:

None

Parameters:

array (Sequence[Sequence[Any]]) –