TopBottom module

class TopBottom.TopBottom

Bases: SpireObject

Represents a top/bottom conditional formatting rule in Excel.

This class provides functionality for configuring top/bottom conditional formatting rules, which highlight cells with values in the top or bottom N values or N percent of a range. For example, highlighting the top 10 values or bottom 5% of values.

property Rank: int

Gets or sets the rank value for the top/bottom rule.

For example, in a “Top 10” rule, the rank would be 10.

Returns:

The rank value.

Return type:

int

property Type: TopBottomType

Gets or sets the type of the top/bottom rule.

Determines whether the rule applies to top or bottom values, and whether it uses a count or percentage.

Returns:

The top/bottom rule type.

Return type:

TopBottomType