python 解析导出excel文件

from urllib.parse import unquote
import xlrd


# 获取导出文件名称
def get_file_name(rsp):
    # header中获取对应的文件名称
    file_name = str(rsp.headers['content-disposition'])
    print(file_name)
    file_name = file_name.split('=', 1)
    save_file_name = unquote(file_name[1])
    # 导出文件默认为ISO-8859-1编码, 处理乱码问题
    save_file_name = save_file_name.encode('ISO-8859-1').decode()
    # 将文件内容保存起来
    with open(save_file_name, 'wb') as code:
        code.write(rsp.content)
    return save_file_name


# 读取导出的excel文件内容
def get_sheet_value(excel_dir, start_row):
    # formatting_info=True 保持原有样式, excel_dir 文件路径
    wook_boot = xlrd.open_workbook(excel_dir, formatting_info=True)
    wook_sheets = wook_boot.sheets()
    # 指定需要执行的sheet
    wook_sheet = wook_sheets[0]
    rows = wook_sheet.nrows
    lists = []
    # 从start_row行开始取值
    for i in range(start_row, rows):
        row_data = wook_sheet.row_values(i)
        data = {}
        for index, key in enumerate(wook_sheet.row_values(1)):
            data[key] = row_data[index]
        lists.append(data)

    return lists