python操作exec'l

import xlrd    # 导包

class Read:
    def __init__(self):
        self.LI = []         # 定义两个列表去装数据，一个装全页的，一个装行的
        self.li = []

    def read_xl(self,sheet):

        book = xlrd.open_workbook('../execl/xpp测试用例_2020031901_黄麟越.xlsx')  # 打开文件
        sheet = book.sheet_by_name(sheet)   #确定获取的页数

        num_rows = sheet.nrows      # 获取行数
        num_cols = sheet.ncols      # 获取列数
        
        count = 0
        for i in range(1,num_rows):                 # 获取单元格的值
            for j in range(num_cols):
                cell = sheet.cell_value(i,j)
                self.li.append(cell)
                count = count+1
                if count%num_cols==0:
                    self.LI.append(self.li)
                    self.li=[]                     # 清空小列表的数据，避免重复添加
        # print(self.LI)
        return self.LI