获取excel数据

获取excel表格数据

import xlrd


class Excel():
    def __init__(self, filename, sheetname='Sheet1'):
        self.data = xlrd.open_workbook(filename)  # 打开excel表
        self.sheet = self.data.sheet_by_name(sheetname)  # 打开工作表
        # 获取总行数，总列数
        self.rows = self.sheet.nrows
        self.ncil = self.sheet.ncols

    def read_data(self):
        if self.rows > 1:
            keys = self.sheet.row_values(0)
            list_API = []
            for i in range(1, self.rows):
                values = self.sheet.row_values(i)
                # key 与 value转化为字典
                api_dict = dict(zip(keys, values))
                list_API.append(api_dict)
            return list_API
        else:
            print('表格数据为空')
            return None


if __name__ == '__main__':
    name = Excel('../Data/test.xls', 'Sheet1').read_data()
    print(name)