> ## Documentation Index
> Fetch the complete documentation index at: https://rpa.bazhuayu.com/helpcenter/llms.txt
> Use this file to discover all available pages before exploring further.

# Excel筛选

## 指令说明

**描述：** 对Excel工作表中的数据进行筛选操作。

## 参数说明

<Tabs>
  <Tab title="常规">
    <img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-01.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=a5c9ee0ba322d33b5a4e0f111eb31f0b" alt="Excel筛选指令参数面板" width="660" height="438" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-01.png" />

    | 参数           | 说明                                                         |
    | ------------ | ---------------------------------------------------------- |
    | **Excel对象**  | 请选择Excel对象（可通过指令【启动Excel】或【获取当前激活的Excel对象】创建），用于确定待操作的工作簿。 |
    | **Sheet页名称** | 操作目标工作表的名称，支持选填，默认为当前Excel激活的Sheet页。                       |
    | **筛选列**      | 输入或选择需要筛选的列号。                                              |
    | **筛选条件**     | 下拉选择筛选条件：等于、不等于、大于、小于、包含、不包含、开头是、结尾是等。                     |
    | **筛选值**      | 输入筛选的目标值。                                                  |
  </Tab>

  <Tab title="高级">
    本指令暂无高级参数。
  </Tab>
</Tabs>

## 使用示例

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-05.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=ff42a31d57e02a2838d05617dfd0bfb1" alt="Excel筛选使用示例" width="660" height="438" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-05.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-06.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=f5ec4d39c9c42ac2aea9e3a79586fcbd" alt="Excel筛选使用示例" width="780" height="654" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-06.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-02.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=b05a2c998d35ddbc7968856171c6e950" alt="Excel筛选使用示例" width="738" height="246" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-02.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-04.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=dea39c691075cadad0f570b25f755d6b" alt="Excel筛选使用示例" width="1321" height="282" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-04.png" />

**该流程执行逻辑：**

使用【启动Excel】打开已有的Excel，并将Excel对象保存到excel对象

使用【Excel筛选】指令对指定列进行条件筛选

### 效果展示

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-03.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=2d2a4d9b21c9fcd1aac15d563584f703" alt="Excel筛选效果展示" width="753" height="284" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-03.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-07.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=0ff0146d09c94636452b1d4bfecec7c6" alt="Excel筛选效果展示" width="878" height="468" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-07.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-08.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=39304106fe69700de3a921ddc2e41a4d" alt="Excel筛选效果展示" width="1920" height="825" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-08.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/filterexcelcolumncommand-09.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=6d31783405fe4d7310608b76691b08ff" alt="Excel筛选效果展示" width="1920" height="825" data-path="helpcenter/commands/excel/images/filterexcelcolumncommand-09.png" />

<Info>
  使用指令过程中遇到问题？前往 [八爪鱼RPA 开发者社区问答板块](https://rpa.bazhuayu.com/community/questions) 提问，获取官方与社区帮助。
</Info>
