django上传Excel文件并将其中的数据显示在页面上_python 上传excel 前端显示

1、html

 <div class="panel panel-default">
                <div class="panel-heading">
                    <span class="glyphicon glyphicon-th-list" aria-hidden="true"></span>
                    批量上传
                </div>
                <div class="panel-body">
                    <form method="post" enctype="multipart/form-data" action="/depart/multi/">
                        {% csrf_token %}
                        <div class="form-group">
                            <input type="file" name="exc">
                        </div>
 
                        <input type="submit" value="上传" class="btn btn-info btn-sm">
                    </form>
                </div>
</div>

2、url  

path('depart/multi/',depart.depart_multi),

3、编写view.py

 
def depart_multi(request):
    from openpyxl import load_workbook
    # 获取用户上传的文件对象
    file_object = request.FILES.get("exc")
 
    # 对象传给openpyxl,由openpyxl读取文件的内容
    wb = load_workbook(file_object)
    sheet = wb.worksheets[0]
    # 循环获取每一行数据
    for row in sheet.iter_rows(min_row=2):
        text = row[0].value
        # print(text)
        # 重复的不加入
        exists = models.Department.objects.filter(title=text).exists()
        if not exists:
            models.Department.objects.create(title=text)
    # 打印表格中第一行第二列的数据，一定要上传xlsx后缀名的excel表，否则会报错
    # cell = sheet.cell(1, 2)
    # print(cell.value)
    return redirect('/depart/list/')

注：一定要上传xlsx后缀名的excel表，否则会报错