|
常用安装包 install.txt pip install selenium pip install openpyxl excle操作封装： import xlrd,xlwt import openpyxl class operExcle: def __init__(self,path=None): if path == None : self.path = "../caseExcle/UI.xlsx" else: self.Path = path self.excle = self.get_excle() #获取excle对象 def get_excle(self): excle = openpyxl.load_workbook(self.path) return excle #获取sheet对象 def get_sheet(self,sheetname = None): if sheetname == None: sheetname ="login" sheet_data =self.excle.get_sheet_by_name(sheetname) return sheet_data #获取最大行 def get_lines(self): total_row = self.get_sheet().max_row return total_row # def get_value(self,row,cell): cell_value = self.get_sheet().cell(row=row,column=cell).value return cell_value def write_data(self,row,cell,content): self.get_sheet().cell(row=row, column=cell).value =content self.excle.save(self.path) if __name__ =="__main__": oper = operExcle() lines = oper.get_lines() print(lines) value=oper.get_value(2,3) oper.write_data(1,1,"123") print(value) |
|
|
