pyexcel.sheets.Matrix

class pyexcel.sheets.Matrix(array)

The internal representation of a sheet data. Each element can be of any python types

__init__(array)

Constructor

The reason a deep copy was not made here is because the data sheet could be huge. It could be costly to copy every cell to a new memory area :param list array: a list of arrays

Methods

__init__(array)	Constructor
cell_value(row, column[, new_value])	Random access to table cells
column_at(index)	Gets the data at the specified column
column_range()	Utility function to get column range
columns()	Returns a left to right column iterator
contains(predicate)	Has something in the table
delete_columns(column_indices)	Delete columns by specified list of indices
delete_rows(row_indices)	Deletes specified row indices
enumerate()	Iterate cell by cell from top to bottom and from left to right
extend_columns(columns)	Inserts two dimensional data after the rightmost column
extend_columns_with_rows(rows)	Rows were appended to the rightmost side
extend_rows(rows)	Inserts two dimensinal data after the bottom row
number_of_columns()	The number of columns
number_of_rows()	The number of rows
paste(topleft_corner[, rows, columns])	Paste a rectangle shaped data after a position
rcolumns()	Returns a right to left column iterator
reverse()	Opposite to enumerate
row_at(index)	Gets the data at the specified row
row_range()	Utility function to get row range
rows()	Returns a top to bottom row iterator
rrows()	Returns a bottom to top row iterator
rvertical()	Default iterator to go through each cell one by one from rightmost
set_column_at(column_index, data_array[, ...])	Updates a column data range
set_row_at(row_index, data_array[, starting])	Update a row data range
to_array()	Get an array out
transpose()	Roate the data table by 90 degrees
vertical()	Default iterator to go through each cell one by one from

Attributes

column
row