> ## 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/deleteexcelduplicaterowcommand-01.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=1454b206b01b73934a5f56c9ccbc2396" alt="删除Excel中的重复行指令参数面板" width="660" height="438" data-path="helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-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/deleteexcelduplicaterowcommand-02.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=53daee6185f00c2f092931db8fe90793" alt="删除Excel中的重复行使用示例" width="562" height="179" data-path="helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-02.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-04.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=6c4747b1fa94aef828e29c5a858148cb" alt="删除Excel中的重复行使用示例" width="648" height="415" data-path="helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-04.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-03.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=0d7eb7619e473b8f513a7a6f445af0ed" alt="删除Excel中的重复行使用示例" width="853" height="283" data-path="helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-03.png" />

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

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

使用【删除Excel中的重复行】指令根据指定列去除重复行

### 效果展示

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-05.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=ea3af3485ee2e6a158eda77e6129229a" alt="删除Excel中的重复行效果展示" width="535" height="221" data-path="helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-05.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/PoBbJh6tQuwbCrmc/helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-06.png?fit=max&auto=format&n=PoBbJh6tQuwbCrmc&q=85&s=5f2a538fb52dcaa2c99cbc79d4d71b1e" alt="删除Excel中的重复行效果展示" width="464" height="199" data-path="helpcenter/commands/excel/images/deleteexcelduplicaterowcommand-06.png" />

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