pyexcel.internal.sheets.Matrix

class pyexcel.internal.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
cut(topleft_corner, bottomright_corner)	Get a rectangle shaped data out and clear them in position
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 dimensional data after the bottom row
filter([column_indices, row_indices])	Apply the filter with immediate effect
format(formatter)	Apply a formatting action for the whole sheet
get_array(**keywords)	Get data in array format
get_bookdict(**keywords)	Get data in bookdict format
get_csv(**keywords)	Get data in csv format
get_csvz(**keywords)	Get data in csvz format
get_dict(**keywords)	Get data in dict format
Matrix.get_grid
get_handsontable_html(**keywords)	Get data in handsontable.html format
Matrix.get_html
get_internal_array()	present internal array
Matrix.get_json
Matrix.get_latex
Matrix.get_latex_booktabs
Matrix.get_mediawiki
get_ods(**keywords)	Get data in ods format
Matrix.get_orgtbl
Matrix.get_pipe
Matrix.get_plain
get_records(**keywords)	Get data in records format
Matrix.get_rst
Matrix.get_simple
get_svg(**keywords)	Get data in svg format
get_texttable(**keywords)	Get data in texttable format
get_tsv(**keywords)	Get data in tsv format
get_tsvz(**keywords)	Get data in tsvz format
get_url(_, **__)	url getter is not defined.
get_xls(**keywords)	Get data in xls format
get_xlsm(**keywords)	Get data in xlsm format
get_xlsx(**keywords)	Get data in xlsx format
map(custom_function)	Execute a function across all cells of the sheet
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
plot([file_type])	Visualize the data
rcolumns()	Returns a right to left column iterator
region(topleft_corner, bottomright_corner)	Get a rectangle shaped data out
register_input(file_type[, instance_name])	partial(func, *args, **keywords) - new function with partial application
register_io(file_type[, presenter_func, ...])	partial(func, *args, **keywords) - new function with partial application
register_presentation(file_type[, ...])
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
save_as(filename, **keywords)	Save the content to a named file
save_to_database(session, table[, ...])	Save data in sheet to database table
save_to_django_model(model[, initializer, ...])	Save to database table through django model
save_to_memory(file_type[, stream])
set_array(content, **keywords)	Set data in array format
set_bookdict(content, **keywords)	Set data in bookdict format
set_column_at(column_index, data_array[, ...])	Updates a column data range
set_csv(content, **keywords)	Set data in csv format
set_csvz(content, **keywords)	Set data in csvz format
set_dict(content, **keywords)	Set data in dict format
Matrix.set_grid
set_handsontable_html(_x, _y, **_z)	handsontable.html setter is not defined.
Matrix.set_html
Matrix.set_json
Matrix.set_latex
Matrix.set_latex_booktabs
Matrix.set_mediawiki
set_ods(content, **keywords)	Set data in ods format
Matrix.set_orgtbl
Matrix.set_pipe
Matrix.set_plain
set_records(content, **keywords)	Set data in records format
set_row_at(row_index, data_array)	Update a row data range
Matrix.set_rst
Matrix.set_simple
set_svg(_x, _y, **_z)	svg setter is not defined.
set_texttable(_x, _y, **_z)	texttable setter is not defined.
set_tsv(content, **keywords)	Set data in tsv format
set_tsvz(content, **keywords)	Set data in tsvz format
set_url(content, **keywords)	Set data in url format
set_xls(content, **keywords)	Set data in xls format
set_xlsm(content, **keywords)	Set data in xlsm format
set_xlsx(content, **keywords)	Set data in xlsx format
to_array()	Get an array out
transpose()	Rotate the data table by 90 degrees
vertical()	Default iterator to go through each cell one by one from

Attributes

array	Get/Set data in/from array format
bookdict	Get/Set data in/from bookdict format
csv	Get/Set data in/from csv format
csvz	Get/Set data in/from csvz format
dict	Get/Set data in/from dict format
Matrix.grid
handsontable_html	Get data in handsontable.html format
Matrix.html
Matrix.json
Matrix.latex
Matrix.latex_booktabs
Matrix.mediawiki
ods	Get/Set data in/from ods format
Matrix.orgtbl
Matrix.pipe
Matrix.plain
records	Get/Set data in/from records format
Matrix.rst
Matrix.simple
stream	Return a stream in which the content is properly encoded
svg	Get data in svg format
texttable	Get data in texttable format
tsv	Get/Set data in/from tsv format
tsvz	Get/Set data in/from tsvz format
url	Set data in url format
xls	Get/Set data in/from xls format
xlsm	Get/Set data in/from xlsm format
xlsx	Get/Set data in/from xlsx format