pyexcel.internal.sheets.Matrix

class pyexcel.internal.sheets.Matrix(array)[source]

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

__init__(array)[source]

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