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 context

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)