python 上传文件（upload），保存临时文件，再以csv和xls格式读取

1. UPload上传保存临时文件

async def upload(file: UploadFile = File(...)):
file_name = file.filename.split(".")[0]
file_suffix = file.filename.split(".")[1]
cur_path = os.path.abspath('.') + os.sep + "upload" + os.sep
full_path = cur_path + file_name + "_file"
# 保存文件
with open(full_path, 'wb') as fw:
res = await file.read()
fw.write(res)

context = {"status": 200, "msg": "success"}
return

2. 读取csv

import csv
def read_csv(full_path):
with codecs.open(full_path, 'r', 'gbk', errors='ignore') as fw:
lines = csv.reader(fr)
for line in lines:
print(line)

3. 读取xls

import xlrd
def read_xls(full_path):
wb = xlrd.open_workbook(full_path)
sheet = wb.sheet_by_index(0) # 获取第一个sheet表数据
for raw in range(1, sheet.nrows - 1):
lines = sheet.row_values(raw)
print(lines)