django导入excel，腾讯+字节+阿里面经真题汇总

f.close()

except Exception as e:

return JsonResponse({‘code’: 500, “message”: “文件上传失败：” + str(e)})

===================== 2.读取存储在Media文件夹的数据 =====================

ex_students = read_excel_dict(file_path)

===================== 3.把读取的数据存储到数据库 =====================

success = 0

error = 0

error_

《Android学习笔记总结+最新移动架构视频+大厂安卓面试真题+项目实战源码讲义》

【docs.qq.com/doc/DSkNLaERkbnFoS0ZF】 完整内容开源分享

snos = []

print(len(ex_students))

print(ex_students)

for one_student in ex_students:

try:

这里是先更新，后增加

obj_student = Student(sno=one_student[‘sno’], name=one_student[‘name’],

gender=one_student[‘gender’], birthday=one_student[‘birthday’],

mobile=one_student[‘mobile’], email=one_student[‘email’],

address=one_student[‘address’])

这里是直接增加

obj_student = Student.objects.create(sno=one_student[‘sno’], name=one_student[‘name’],

gender=one_student[‘gender’], birthday=one_student[‘birthday’],

mobile=one_student[‘mobile’], email=one_student[‘email’],

address=one_student[‘address’])

obj_student.save()

计数

success += 1

except Exception as e:

error += 1

error_snos.append(one_student[‘sno’])

===================== 4.返回——导入信息 =====================

return JsonResponse(

{‘code’: 200, “data”: {“success”: success, “error”: error, “info”: error_snos}, “message”: “操作成功”})

def read_excel_dict(path: str):

“”"

读取excel数据

:param path:

:return:

“”"

实例化一个wrokbook

wrokbook = openpyxl.load_workbook(path)

实例化一个sheet(‘student’:指的是默认读取student表格)

sheet = wrokbook[‘student’]

定义一个变量存储最终的数据

students = []

准备key

keys = [‘sno’, ‘name’, ‘gender’, ‘birthday’, ‘mobile’, ‘email’, ‘address’]

遍历

for row in sheet.rows:

定义一个临时的字典

temp_dict = {}

组合值和key

for index, cell in enumerate(row):

组合

if keys[index] == ‘sno’ and cell.value is None:

break

temp_dict[keys[index]] = cell.value

附加到list中

if temp_dict:

students.append(temp_dict)

返回

if len(students) > 0:

return students[1:]

else:

return students

• urls.py配置

urlpatterns = [

url(路径，视图)

url(r’^students/importStudentExcel/$’, views.import_student_excel)

]

• 前端代码

<el-upload

action=""

:show-file-list=“false”

:http-request=“uploadExcelPost”

导入Excel

const Api = {

ImportStudentExcel:’/student/students/importStudentExcel/’,

}

/**

• 导入Excel

• json请求

• @param parameter

• @returns {*}

*/

export function importStudentExcel(parameter) {

return request({

url: Api.ImportStudentExcel,

method: ‘post’,

// data: qs.stringify(parameter)

data: parameter

})

}

/ 导入excel

uploadExcelPost(file) {

const fileReq = new FormData()

fileReq.append(‘excel’, file.file)

importStudentExcel(fileReq)

.then((res) => {

if (res.data.error > 0) {

this.$message.info(

‘本次导入完成，成功：’ +

res.data.success +

‘条，失败：’ +

res.data.error +

‘条，失败的学员学号为：’+JSON.stringify(res.data.info)