在写框架的时候,一个文件里肯定不止会有一个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)