pyexcel.sheets.FilterableSheet

class pyexcel.sheets.FilterableSheet(sheet)

A represetation of Matrix that can be filtered by as many filters as it is applied

__init__(sheet)

Methods

__init__(sheet)
add_filter(afilter)	Apply a filter
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_filters()	Clears all filters
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
cut(topleft_corner, bottomright_corner)	Get a rectangle shaped data out and clear them in position
delete_columns(*args)
delete_rows(*args)
enumerate()	Iterate cell by cell from top to bottom and from left to right
extend_columns(*args)
extend_columns_with_rows(rows)	Rows were appended to the rightmost side
extend_rows(*args)
filter(afilter)	Apply the filter with immediate effect
format(formatter[, on_demand])	Apply a formatting action for the whole sheet
freeze_filters()	Apply all filters and delete them
freeze_formatters()	Apply all added formatters and clear them
insert(topleft_corner[, rows, columns])	Insert a rectangle shaped data after a position
map(custom_function)	Execute a function across all cells of the sheet
number_of_columns()	Number of columns in the data sheet
number_of_rows()	Number of rows in the data sheet
paste(topleft_corner[, rows, columns])	Paste a rectangle shaped data after a position
rcolumns()	Returns a right to left column iterator
region(topleft_corner, bottomright_corner)	Get a rectangle shaped data out
remove_filter(afilter)	Remove a named filter
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
validate_filters()	Re-apply filters
vertical()	Default iterator to go through each cell one by one from

Attributes

column
row