step1: 读取上传的excel数据并存档
step2: 读取存入本地的excel文件,对内容进行处理,其中包含日期格式处理
重点代码:
issueDate = sheetContent.cell(row,1).value
date_value = xlrd.xldate_as_tuple(issueDate,workbook.datemode)
import datetime
issueDate = datetime.date(*date_value[:3]).strftime("%Y-%m-%d")
print(issueDate)
def uploadIssue(request):
if request.method=="GET":
return render(request,"addUploadIssue.html")
else:
file = request.FILES.get("files")
if file:
print(file.name, file.size)
#step1 先进行保存
from ctcqs import settings
import uuid,os
new_fileName = str(uuid.uuid4())+file.name
new_filePath = os.path.join(settings.MEDIA_ROOT,"temp",new_fileName)
new_f