AutoFilter

Vue de l’ensemble

‘AutoFilter’ est une classe dans Aspose.Cells FOSS pour Python.

Représente les filtres automatiques dans un feuille de travail.

Cette classe fournit 15 méthodes pour travailler avec des objets AutoFilter dans les programmes Python. Les méthodologies disponibles comprennent: __init__, add_filter , clear_all_filters ; custom_ filter‘, 'filtre : filtrer_by_color; filer_dynamic: ‘filler_top10. get_file_column., has_films et 3 méthode supplémentaires. Tous les membres publics sont accessibles à toute application Pythone après l’installation de l’Aspose.Cell FOSS pour le package PyThone. Propriétés:filters_culumns,, range sortstate.

Propriétés

Name	Type	Access	Description
`range`	``	Read/Write	Gets or sets the filter range.
`filter_columns`	``	Read	Gets the collection of filter columns.
`sort_state`	``	Read/Write	Gets or sets the sort state settings.

méthodes

Signature	Description
`__init__()`	Initializes a new instance of the AutoFilter class.
`set_range(start_row, start_col, end_row, end_col)`	Sets the filter range using row and column indices.
`filter(col_index, values)`	Applies a filter to a specific column.
`add_filter(col_index, value)`	Adds a filter value to a specific column.
`custom_filter(col_index, operator, value)`	Applies a custom filter to a specific column.
`filter_by_color(col_index, color, cell_color)`	Applies a color filter to a specific column.
`filter_top10(col_index, top, percent, val)`	Applies a top 10 filter to a specific column.
`filter_dynamic(col_index, filter_type, value)`	Applies a dynamic filter to a specific column.
`clear_column_filter(col_index)`	Clears the filter for a specific column.
`clear_all_filters()`	Clears all filters.
`remove()`	Removes the auto filter from the worksheet.
`show_filter_button(col_index, show)`	Shows or hides the filter button for a specific column.
`sort(col_index, ascending)`	Sets the sort order for a specific column.
`get_filter_column(col_index)`	Gets the filter column for a specific column index.
`has_filter(col_index)`	Checks if a specific column has filters applied.

Voir aussi

Aspose.Cells pour Python — Enterprise API Reference