openpyxl 读取execl 文件（二）多个sheet

最新推荐文章于 2025-03-05 10:52:55 发布

东贝鸟

最新推荐文章于 2025-03-05 10:52:55 发布

阅读量4.5k

点赞数 2

分类专栏：自动化框架

本文链接：https://blog.youkuaiyun.com/weixin_45393723/article/details/105528313

版权

自动化框架专栏收录该内容

3 篇文章

订阅专栏

在写框架的时候，一个文件里肯定不止会有一个sheet
我的思路是：取出全部的数据，放在一个列表里。在根据下标去读取
在这里插入图片描述

在这里插入图片描述

[[['', 'open', '', '', 'http://lanlin*********-login', '', ''], ['', 'click', 'By.ID', 'account', '', '', ''], ['', 'type', 'By.ID', 'account', 11.0, '', ''], ['', 'click', 'By.ID', 'password', '', '', ''], ['', 'type', 'By.ID', 'password', 818283.0, '', ''], ['', 'click', 'By.ID', 'isRmbPwd', '', '', ''], ['', 'click', 'By.ID', 'login-btn', '', '', ''], ['', 'click', 'By.XPATH', '//label', '', '', ''], ['', 'move', 'By.LINK_TEXT', '云盘中心', '', '', ''], ['', 'click', 'By.LINK_TEXT', '我的云盘', '', '', ''], ['', 'click', 'By.ID', 'ztree_3_span', '', '', ''], ['', 'click', 'By.XPATH', "(//button[@type='button'])[9]", '', '', ''], ['', 'find', 'By.ID', 'fileupload', '', '', ''], ['', 'file_input', 'By.NAME', 'fileLogicContent', 'H:\\上班\\kdt\\file\\test', '', ''], ['', 'find', 'By.ID', 'fileupload', '', '', ''], ['', 'click', 'By.CLASS_NAME', 'btn.btn-primary.start.shangchuan', '', '', '']], '云盘', [['', 'open', '', '', 'http://la************g-login', '', '', ''], ['', 'click', 'By.ID', 'account', '', '', '', ''], ['', 'type', 'By.ID', 'account', 11.0, '', '', ''], ['', 'click', 'By.ID', 'password', '', '', '', ''], ['', 'type', 'By.ID', 'password', 818283.0, '', '', ''], ['', 'click', 'By.ID', 'isRmbPwd', '', '', '', ''], ['', 'click', 'By.ID', 'login-btn', '', '', '', ''], ['', 'click', 'By.XPATH', '//li[2]/ul/li/a/span', '', '', '', ''], ['', 'click', 'By.LINK_TEXT', '商品详情', '', '', '', ''], ['', 'selectWindow', '', '', '', '', '', ''], ['', 'click', 'By.LINK_TEXT', '立即购买', '', '', '', ''], ['', 'click', 'By.XPATH', "//input[@type='text']", '', '', '', ''], ['', 'send_Keys', '', 9.0, '', '', '', ''], ['', 'send_Keys', '', 1.0, '', '', '', ''], ['', 'send_Keys', '', 9.0, '', '', '', ''], ['', 'send_Keys', '', 2.0, '', '', '', ''], ['', 'send_Keys', '', 9.0, '', '', '', ''], ['', 'send_Keys', '', 3.0, '', '', '', ''], ['', 'click', 'By.ID', 'payBtn', '', '', '', ''], ['', 'click', 'By.ID', 'ok_btn', '', '', '', ''], ['', 'close', '', '', '', '', '', ''], ['', 'selectWindow', '', '', '', '', '', ''], ['', 'get_time', 'By.XPATH', '/html/body/div[1]/div/div[2]/div[1]/div[3]/div[3]/div[1]/div[1]/span[1]', '', '', '', ''], ['', 'get', 'By.XPATH', '/html/body/div[1]/div/div[2]/div[1]/div[3]/div[4]/div[1]/div[1]/span[3]', '', '卖家昵称帐号：斗拱1号', '', ''], ['', 'quit', '', '', '', '', '', '']], '南二购买', [['', 'open', '', '', 'https://www.baidu.com/', '', '', ''], ['', 'click', 'By.ID', 'virus-2020', '', '', '', ''], ['', 'selectWindow', '', '', '', '', '', ''], ['', 'click', 'By.XPATH', "//div[@id='ptab-0']/div[2]/div/div/label", '', '', '', ''], ['', 'assert', '', '', '', '', '', ''], ['', 'quit', '', '', '', '', '', '']], '百度', [['', 'open', '', '', 'https://www.163.com/', '', '', ''], ['', 'click', 'By.XPATH', "(//a[contains(text(),'新闻')])[3]", '', '', '', ''], ['', 'selectWindow', '', '', '', '', '', ''], ['', 'click', 'By.LINK_TEXT', '数读', '', '', '', ''], ['', 'selectWindow', '', '', '', '', '', ''], ['', 'click', 'By.XPATH', '//li[4]/a/h4', '', '', '', ''], ['', 'assert', '', '', '', '', '', ''], ['', 'quit', '', '', '', '', '', '']], '网易']

    def read_xl(self,path):    
        wb = load_workbook(path)    # 打开文件
        for i in wb:                    # 遍历sheet
            sheet = wb[i.title]          # 切换sheet
            sheet = sheet.title
            self.sheet_name = sheet
            self.LI = []                    # 清空列表
            self.list,self.rows = self.read_x(path, sheet)      # 我的下面的那个函数是读取单元格数的方法
            self.big_li.append(self.list)
            self.big_li.append(self.sheet_name)