> ## 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

## 1. 应用说明

通过本应用可以实现依次读取Excel文件中存放的关键词，在某网页上输入不同的关键词后进行搜索。

<div className="h-8" />

## 2. 应用实现逻辑

### 模拟、分析人操作全流程

第一步：打开人民网（示例网址：[http://search.people.cn/](http://search.people.cn/)）

<img src="https://mintcdn.com/bazhuayu-rpa-docs/Un9xnU9PbcHvf1QO/helpcenter/getting-started/examples/images/PpKkq8-01.png?fit=max&auto=format&n=Un9xnU9PbcHvf1QO&q=85&s=cd29e5c9186195eff4da7b24c57e6042" alt="单网页多关键词搜索-Excel" width="1920" height="999" data-path="helpcenter/getting-started/examples/images/PpKkq8-01.png" />

第二步：循环Excel文件，往人民网输入框中填写循环到的第一个关键词“美丽中国”

<img src="https://mintcdn.com/bazhuayu-rpa-docs/Un9xnU9PbcHvf1QO/helpcenter/getting-started/examples/images/PpKkq8-02.png?fit=max&auto=format&n=Un9xnU9PbcHvf1QO&q=85&s=5d4aa01794b5f182148b2394f55b41a6" alt="单网页多关键词搜索-Excel" width="1600" height="900" data-path="helpcenter/getting-started/examples/images/PpKkq8-02.png" />

第三步：循环Excel文件，往人民网输入框中填写循环到的第二个关键词“创新”

<img src="https://mintcdn.com/bazhuayu-rpa-docs/Un9xnU9PbcHvf1QO/helpcenter/getting-started/examples/images/PpKkq8-03.png?fit=max&auto=format&n=Un9xnU9PbcHvf1QO&q=85&s=490a1a89cce4f04f1ed1bf2d05e1cd4a" alt="单网页多关键词搜索-Excel" width="1600" height="900" data-path="helpcenter/getting-started/examples/images/PpKkq8-03.png" />

依此类推，直至当前Excel文件中所有关键词都循环完毕。

### RPA流程图

<img src="https://mintcdn.com/bazhuayu-rpa-docs/Un9xnU9PbcHvf1QO/helpcenter/getting-started/examples/images/PpKkq8-04.jpg?fit=max&auto=format&n=Un9xnU9PbcHvf1QO&q=85&s=90c076754689a0fd61f88f32b474a526" alt="单网页多关键词搜索-Excel" width="488" height="775" data-path="helpcenter/getting-started/examples/images/PpKkq8-04.jpg" />

<div className="h-8" />

## 3. 应用实现

打开指定网页，启动Excel文件，读取Excel里所有关键词。每读取一个关键词就填写一次输入框，直到所有关键词都搜索完毕。

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-05.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=f08dc9261754f0bd7cb1a8332f9a1643" alt="单网页多关键词搜索-Excel" width="1370" height="343" data-path="helpcenter/getting-started/examples/images/PpKkq8-05.png" />

### 前期准备

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-06.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=64a9d2161577cda80abdcb064dc72f2e" alt="单网页多关键词搜索-Excel" width="1135" height="705" data-path="helpcenter/getting-started/examples/images/PpKkq8-06.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-07.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=11a2563b1ae7014ae086995e494150bb" alt="单网页多关键词搜索-Excel" width="778" height="377" data-path="helpcenter/getting-started/examples/images/PpKkq8-07.png" />

① 首先我们需要一个用于存放关键词的 Excel 文件

③ 在 Excel 文件中第一列中依次添加需要搜索的关键词，如“美丽中国、创新、乡村振兴”等

### 流程指令解析

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-08.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=c35bceb6f3d6c455863d906dfcd7ce0f" alt="单网页多关键词搜索-Excel" width="647" height="409" data-path="helpcenter/getting-started/examples/images/PpKkq8-08.png" />

按照习惯选择常用的浏览器类型，可选八爪鱼浏览器、谷歌浏览器、Edge浏览器等，网址则填写”人民网“的网址([http://search.people.cn/](http://search.people.cn/))，最后将此网页对象命名为人民网。

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-09.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=ae9e19ff9b3e1d46e500d31bb297db34" alt="单网页多关键词搜索-Excel" width="653" height="532" data-path="helpcenter/getting-started/examples/images/PpKkq8-09.png" />

在进入循环体输入关键词前，需要先启动 Excel，让 RPA 获取Excel文件对象里面的数据。 使用【启动Excel】指令，选择Excel表的存储路径，并将当前文件对象命名为“搜索关键词”。

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-10.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=1f5f0cf160df0425e724344fbf2598c9" alt="单网页多关键词搜索-Excel" width="651" height="524" data-path="helpcenter/getting-started/examples/images/PpKkq8-10.png" />

依次循环 Excel 中的每一个关键词，循环的 Excel 对象选择刚才创建的“搜索关键词”，并且把当前循环到的关键词命名为当前关键词。

**注：** 这里的循环项指的是Excel里的一行（不是一列，也不是一个单元格）。因此每个循环项实际上都是列表。

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-11.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=9acb655d5ba3afb84473ef5aeb3445ba" alt="单网页多关键词搜索-Excel" width="652" height="664" data-path="helpcenter/getting-started/examples/images/PpKkq8-11.png" />

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-12.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=e21bc7d0fd78d301a500ab781a6979c4" alt="单网页多关键词搜索-Excel" width="1920" height="1040" data-path="helpcenter/getting-started/examples/images/PpKkq8-12.png" />

①选择元素，点击【捕获新元素】按钮，捕获打开的人民网网页输入框

②按住Ctrl+鼠标左键捕获输入框位置

③在输入框内输入我们要搜索的当前关键词

**注：** Excel每一行都是一维列表，因此需要输入索引值。即当前关键词\[0]。相关文档：[变量填写到输入框为什么会有\[""\]](https://rpa.bazhuayu.com/community/question/249)

④勾选“输入完成后按下回车键”

### 运行效果

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-13.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=203dba5066d2f6973c3ab5658920f241" alt="单网页多关键词搜索-Excel" width="1600" height="900" data-path="helpcenter/getting-started/examples/images/PpKkq8-13.png" />

<div className="h-8" />

## 4. 更多案例

<span style={{ color: '#9ca3af' }}>（本案例模式适用于需要搜索多关键词的网页）</span>

淘宝、京东搜索商品

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-14.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=8914aac2747b265860647bf212c87321" alt="单网页多关键词搜索-Excel" width="1872" height="966" data-path="helpcenter/getting-started/examples/images/PpKkq8-14.png" />

百度搜索

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-15.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=802223625fdbe73e3a7ff5aab9b62fb3" alt="单网页多关键词搜索-Excel" width="1872" height="966" data-path="helpcenter/getting-started/examples/images/PpKkq8-15.png" />

Boss直聘找工作

<img src="https://mintcdn.com/bazhuayu-rpa-docs/D6MJZZ__w_5ViTWO/helpcenter/getting-started/examples/images/PpKkq8-16.png?fit=max&auto=format&n=D6MJZZ__w_5ViTWO&q=85&s=f96de5a4036fb9a10a44128609ad6c3c" alt="单网页多关键词搜索-Excel" width="1872" height="966" data-path="helpcenter/getting-started/examples/images/PpKkq8-16.png" />
