Aspose.Cells FOSS

AutoFilter

AutoFilter — Aspose.Cells FOSS Python API Reference

AutoFilter — AutoFilter class in the Aspose.Cells FOSS Python API..

Package: aspose.cells_foss

Properties

Property	Type	Access	Description
`range`	``	Read/Write
`filter_columns`	``	Read/Write
`sort_state`	``	Read/Write

Methods

Method	Returns	Description
`range()`	`void`
`filter_columns()`	`void`
`sort_state()`	`void`
`set_range(start_row, start_col, end_row, end_col)`	`void`
`filter(col_index, values)`	`void`
`add_filter(col_index, value)`	`void`
`custom_filter(col_index, operator, value)`	`void`
`filter_by_color(col_index, color, cell_color)`	`void`
`filter_top10(col_index, top, percent, val)`	`void`
`filter_dynamic(col_index, filter_type, value)`	`void`
`clear_column_filter(col_index)`	`void`
`clear_all_filters()`	`void`
`remove()`	`void`
`show_filter_button(col_index, show)`	`void`
`sort(col_index, ascending)`	`void`
`get_filter_column(col_index)`	`void`
`has_filter(col_index)`	`void`

See Also

Aspose.Cells FOSS Python API Reference home