django存文件到mysql_（五）django上传文件并读取相应数据存入数据库

file_name = str(File).split('.')[0]

now = time.localtime(time.time())

insert_time = time.strftime("%Y%m%d%H%M%S", now)

qs = Users.objects.filter(id=uid).first()

# 上传文件

File.name = file_name + str(uid) + insert_time

f = open(os.path.join('static/media/sc_upload', File.name), 'wb+')

for chunk in File.chunks(): # 保证大文件不会使用大量内存

f.write(chunk)

f.close()

wb = xlrd.open_workbook('static/media/sc_upload/' + File.name)

# 第一个sheet

ws = wb.sheets()[0]

rows = 2

cols = 4

hang = []

for row in range(1, rows):

for col in range(0, cols):

zhi = ws.cell(1, col).value

hang.append(zhi)

# 存储文件信息

now = insert_time[0:4] + '-' + insert_time[4:6] + '-' \