一、首先读文件需要ExcelLibrary包支持
1.安装ExcelLibrary
可以直接通过命令安装:pip install robotframework-ExcelLibrary
![img_17c4ecf0750af30e47153f27da7a962a.png](https://yqfile.alicdn.com/img_17c4ecf0750af30e47153f27da7a962a.png?x-oss-process=image/resize,w_1400/format,webp)
robotframework-ExcelLibrary
2.检查是否安装成功
pip list
![img_f3f66356e5ac613db16532631d7f38cc.png](https://yqfile.alicdn.com/img_f3f66356e5ac613db16532631d7f38cc.png?x-oss-process=image/resize,w_1400/format,webp)
pip list
二、环境配置
1.新建file.xls (Excel文档),并填入以下数据,保存sheet名为mytext
![img_ae7d8a289701f1742484d9363b964ef9.png](https://yqfile.alicdn.com/img_ae7d8a289701f1742484d9363b964ef9.png?x-oss-process=image/resize,w_1400/format,webp)
file.xls文档
2.撰写测试代码
导入库文件
![img_0ebb1679401926c74b54677c502a5e62.png](https://yqfile.alicdn.com/img_0ebb1679401926c74b54677c502a5e62.png?x-oss-process=image/resize,w_1400/format,webp)
库文件
具体实现如下
![img_2de2ae18e65cbed14d4636dbf8e7c726.png](https://yqfile.alicdn.com/img_2de2ae18e65cbed14d4636dbf8e7c726.png?x-oss-process=image/resize,w_1400/format,webp)
测试代码
3.运行结果
![img_e0c571669dce83cdd15fb4fedf14dcd2.png](https://yqfile.alicdn.com/img_e0c571669dce83cdd15fb4fedf14dcd2.png?x-oss-process=image/resize,w_1400/format,webp)
运行结果
4.测试报告
![img_bdbbc6175466d53797d618c09c410292.png](https://yqfile.alicdn.com/img_bdbbc6175466d53797d618c09c410292.png?x-oss-process=image/resize,w_1400/format,webp)
Report