常用安裝包 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對(duì)象

    def get_excle(self):

        excle = openpyxl.load_workbook(self.path)

        return excle

    #獲取sheet對(duì)象

    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)