筛选指南
应用场景
支持的接口
筛选参数
filtered_out_rows
range
1.
2.
3.
4.
5.
col
filter_type
1.
2.
3.
4.
5.
{
"condition": {
"filter_type": "multiValue",
"expected": ["100", "200", "300"]
}
}| compare_type | expected 长度 | 备注 |
|---|---|---|
| equal | 1 | 数字筛选：等于 |
| notEqual | 1 | 数字筛选：不等于 |
| greater | 1 | 数字筛选：大于 |
| greaterOrEqual | 1 | 数字筛选：大于等于 |
| less | 1 | 数字筛选：小于 |
| lessOrEqual | 1 | 数字筛选：小于等于 |
| between | 2 | 数字筛选：介于 |
| notBetween | 2 | 数字筛选：不介于 |
{
"condition": {
"filter_type": "number",
"compare_type": "equal",
"expected": ["100"]
},
"condition": {
"filter_type": "number",
"compare_type": "between",
"expected": ["100", "200"]
}
}| compare_type | expected 长度 | 备注 |
|---|---|---|
| beginsWith | 1 | 文本筛选：开头是 |
| notBeginsWith | 1 | 文本筛选：开头不是 |
| endsWith | 1 | 文本筛选：结尾是 |
| notEndsWith | 1 | 文本筛选：结尾不是 |
| contains | 1 | 文本筛选：包含 |
| notContains | 1 | 文本筛选：不包含 |
{
"condition": {
"filter_type": "text",
"compare_type": "contains",
"expected": ["abc"]
}
}| compare_type | expected 长度 | 备注 |
|---|---|---|
| backColor | 1 | 颜色筛选：单元格颜色 |
| foreColor | 1 | 颜色筛选：字体颜色 |
{
"condition": {
"filter_type": "color",
"compare_type": "backColor",
"expected": ["#ffffff"]
}
}{
"condition": {
"filter_type": "clear",
}
}
扫码加入交流群修改于 2023-01-18 06:04:59