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
python 解析导出excel文件
最新推荐文章于 2024-04-30 16:37:31 发布