基于Selenium与Openpyxl的Web脚本自动化设计研究

Research on Web Script Automation Design Based on Selenium and Openpyxl

Python包含大量官方库,可以实现种类繁多的编程工作,如Selenium库可实现自动化测试,Openpyxl库可操作excel数据表,这些库可以极大地节约时间,提升工作效率。通过一个具体案例的设计实现过程阐述了如何采用Python的seleni⁃um、openpyxl等实现Web脚本自动化操作,解决了项目中大量重复性工作的自动化实现目标。

Python contains a large number of official libraries,which can realize a wide range of programming work.For example,seleni⁃um library can realize automatic testing,openpyxl library can operate Excel data tables,which can greatly save time and improve work efficiency.Through the design and implementation of a specific case,this paper expounds how to use the selenium and openpyxl of Py⁃thon to realize the automatic operation of Web script,and solves the automatic realization goal of a large number of repetitive work in the project.