import openpyxl
import time
def import_user(*_arg, **_kwarg):
try:
CONTENTS = request.files.get('content')
# 打开excel文件,获取工作簿对象
#这里我先把文件上传,然后再获取到url路径
if CONTENTS:
folder_url = 'excel'
result = upload_files_by_folder_name(CONTENTS, folder_url)
if 'error' in result[0]:
print(result[0]['error'])
else:
url = result[0]['dirname'] + '/' + result[0]['filename']
else:
return 0
wb = openpyxl.load_workbook(url)
# 从表单中获取单元格的内容
sheet = wb['数据录入'] # 当前表单
error_elder = []
rows = int(sheet.max_row) + 1 #加1是因为循环是因为取不到rows,是小于,不包含rows
#从第二行开始遍历,第一行是标题
for i in range(2, rows):
name = sheet.cell(i, 1).value #姓名
Python 从excel中导入数据
最新推荐文章于 2023-09-22 14:50:22 发布