pyexcel.sheets.FormattableSheet

class pyexcel.sheets.FormattableSheet(array)

A represetation of Matrix that accept custom formatters

__init__(array)

Constructor

Methods

__init__(array)	Constructor
add_formatter(aformatter)	Add a lazy formatter.
apply_formatter(aformatter)	Apply the formatter immediately.
cell_value(row, column[, new_value])	Random access to the data cells
clear_formatters()	Clear all formatters
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
format(formatter[, on_demand])	Apply a formatting action for the whole sheet
freeze_formatters()	Apply all added formatters and clear them
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
rcolumns()	Returns a right to left column iterator
remove_formatter(aformatter)	Remove a formatter
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