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 -