openpyxl.worksheet.filters.
AutoFilter
(
ref=None
,
filterColumn=()
,
sortState=None
,
extLst=None
)
[source]
¶
add_filter_column
(
col_id
,
vals
,
blank=False
)
[source]
¶
Add row filter for specified column.
| 参数： |
|
|---|
add_sort_condition
(
ref
,
descending=False
)
[source]
¶
Add sort condition for cpecified range of cells.
| 参数： |
|
|---|
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
filterColumn
¶
A sequence (list or tuple) that may only contain objects of the declared type
ref
¶
sortState
¶
Values must be of type <class ‘openpyxl.worksheet.filters.SortState’>
tagname
= 'autoFilter'
¶
cellColor
¶
Values must be of type <class ‘bool’>
dxfId
¶
Values must be of type <class ‘int’>
tagname
= 'colorFilter'
¶
operator
¶
Value must be one of {‘lessThan’, ‘lessThanOrEqual’, ‘greaterThan’, ‘greaterThanOrEqual’, ‘notEqual’, ‘equal’}
tagname
= 'customFilter'
¶
val
¶
Values must be of type <class ‘str’>
customFilter
¶
A sequence (list or tuple) that may only contain objects of the declared type
tagname
= 'customFilters'
¶
openpyxl.worksheet.filters.
DateGroupItem
(
year=None
,
month=None
,
day=None
,
hour=None
,
minute=None
,
second=None
,
dateTimeGrouping=None
)
[source]
¶
dateTimeGrouping
¶
Value must be one of {‘month’, ‘minute’, ‘day’, ‘second’, ‘year’, ‘hour’}
day
¶
Values must be of type <class ‘float’>
hour
¶
Values must be of type <class ‘float’>
minute
¶
Values must be of type <class ‘float’>
month
¶
Values must be of type <class ‘float’>
second
¶
Values must be of type <class ‘int’>
tagname
= 'dateGroupItem'
¶
year
¶
Values must be of type <class ‘int’>
openpyxl.worksheet.filters.
DynamicFilter
(
type=None
,
val=None
,
valIso=None
,
maxVal=None
,
maxValIso=None
)
[source]
¶
maxVal
¶
Values must be of type <class ‘float’>
maxValIso
¶
Values must be of type <class ‘datetime.datetime’>
tagname
= 'dynamicFilter'
¶
type
¶
Value must be one of {‘nextMonth’, ‘Q1’, ‘M9’, ‘lastYear’, ‘M6’, ‘today’, ‘belowAverage’, ‘Q4’, ‘M1’, ‘M2’, ‘M7’, ‘aboveAverage’, ‘nextQuarter’, ‘thisQuarter’, ‘Q3’, ‘Q2’, ‘lastWeek’, ‘M12’, ‘M3’, ‘yearToDate’, ‘lastMonth’, ‘thisWeek’, ‘nextWeek’, ‘thisYear’, ‘yesterday’, ‘M4’, ‘nextYear’, ‘M10’, ‘null’, ‘M8’, ‘thisMonth’, ‘lastQuarter’, ‘tomorrow’, ‘M11’, ‘M5’}
val
¶
Values must be of type <class ‘float’>
valIso
¶
Values must be of type <class ‘datetime.datetime’>
openpyxl.worksheet.filters.
FilterColumn
(
colId=None
,
hiddenButton=None
,
showButton=None
,
filters=None
,
top10=None
,
customFilters=None
,
dynamicFilter=None
,
colorFilter=None
,
iconFilter=None
,
extLst=None
,
blank=None
,
vals=None
)
[source]
¶
colId
¶
Values must be of type <class ‘int’>
col_id
¶
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)
colorFilter
¶
Values must be of type <class ‘openpyxl.worksheet.filters.ColorFilter’>
customFilters
¶
Values must be of type <class ‘openpyxl.worksheet.filters.CustomFilters’>
dynamicFilter
¶
Values must be of type <class ‘openpyxl.worksheet.filters.DynamicFilter’>
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
过滤
¶
Values must be of type <class ‘openpyxl.worksheet.filters.Filters’>
Values must be of type <class ‘bool’>
iconFilter
¶
Values must be of type <class ‘openpyxl.worksheet.filters.IconFilter’>
showButton
¶
Values must be of type <class ‘bool’>
tagname
= 'filterColumn'
¶
top10
¶
Values must be of type <class ‘openpyxl.worksheet.filters.Top10’>
openpyxl.worksheet.filters.
过滤器
(
blank=None
,
calendarType=None
,
filter=()
,
dateGroupItem=()
)
[source]
¶
blank
¶
Values must be of type <class ‘bool’>
calendarType
¶
Value must be one of {‘thai’, ‘hijri’, ‘saka’, ‘gregorianXlitFrench’, ‘gregorian’, ‘gregorianArabic’, ‘gregorianUs’, ‘gregorianMeFrench’, ‘korea’, ‘taiwan’, ‘japan’, ‘gregorianXlitEnglish’, ‘hebrew’}
dateGroupItem
¶
A sequence (list or tuple) that may only contain objects of the declared type
filter
¶
A sequence of primitive types that are stored as a single attribute. “val” is the default attribute
tagname
= 'filters'
¶
iconId
¶
Values must be of type <class ‘int’>
iconSet
¶
Value must be one of {‘3Symbols2’, ‘4ArrowsGray’, ‘4RedToBlack’, ‘3TrafficLights2’, ‘3Flags’, ‘5Arrows’, ‘3Symbols’, ‘3Signs’, ‘5Rating’, ‘5ArrowsGray’, ‘5Quarters’, ‘4Rating’, ‘3ArrowsGray’, ‘3Arrows’, ‘4TrafficLights’, ‘4Arrows’, ‘3TrafficLights1’}
tagname
= 'iconFilter'
¶
openpyxl.worksheet.filters.
SortCondition
(
ref=None
,
descending=None
,
sortBy=None
,
customList=None
,
dxfId=None
,
iconSet=None
,
iconId=None
)
[source]
¶
customList
¶
Values must be of type <class ‘str’>
descending
¶
Values must be of type <class ‘bool’>
dxfId
¶
Values must be of type <class ‘int’>
iconId
¶
Values must be of type <class ‘int’>
iconSet
¶
Value must be one of {‘3Symbols2’, ‘4ArrowsGray’, ‘4RedToBlack’, ‘3TrafficLights2’, ‘3Flags’, ‘5Arrows’, ‘3Symbols’, ‘3Signs’, ‘5Rating’, ‘5ArrowsGray’, ‘5Quarters’, ‘4Rating’, ‘3ArrowsGray’, ‘3Arrows’, ‘4TrafficLights’, ‘4Arrows’, ‘3TrafficLights1’}
ref
¶
sortBy
¶
Value must be one of {‘fontColor’, ‘value’, ‘cellColor’, ‘icon’}
tagname
= 'sortCondition'
¶
openpyxl.worksheet.filters.
SortState
(
columnSort=None
,
caseSensitive=None
,
sortMethod=None
,
ref=None
,
sortCondition=()
,
extLst=None
)
[source]
¶
caseSensitive
¶
Values must be of type <class ‘bool’>
columnSort
¶
Values must be of type <class ‘bool’>
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
ref
¶
sortCondition
¶
A sequence (list or tuple) that may only contain objects of the declared type
sortMethod
¶
Value must be one of {‘pinYin’, ‘stroke’}
tagname
= 'sortState'
¶
openpyxl.worksheet.filters.
Top10
(
top=None
,
percent=None
,
val=None
,
filterVal=None
)
[source]
¶
filterVal
¶
Values must be of type <class ‘float’>
percent
¶
Values must be of type <class ‘bool’>
tagname
= 'top10'
¶
top
¶
Values must be of type <class ‘bool’>
val
¶
Values must be of type <class ‘float’>