Django读取excel (xlsx)文件以在表格中显示

pip install openpyxl django-import-export

INSTALLED_APPS = [
    # ...
    'import_export',
]

# models.py
from django.db import models

class Person(models.Model):
    name = models.CharField(max_length=100)
    age = models.IntegerField()

# resources.py
from import_export import resources
from .models import Person

class PersonResource(resources.ModelResource):
    class Meta:
        model = Person

# views.py
from django.shortcuts import render
from .models import Person
from .resources import PersonResource

def upload_excel(request):
    if request.method == 'POST':
        person_resource = PersonResource()
        result = person_resource.import_data(request.FILES['file'], dry_run=True)
        if result.has_errors():
            # 处理错误
            pass
        else:
            person_resource.import_data(request.FILES['file'], dry_run=False)
            persons = Person.objects.all()
            return render(request, 'table.html', {'persons': persons})
    return render(request, 'upload.html')

def table(request):
    persons = Person.objects.all()
    return render(request, 'table.html', {'persons': persons})

<!-- upload.html -->
<form method="post" enctype="multipart/form-data">
  {% csrf_token %}
  <input type="file" name="file">
  <button type="submit">上传</button>
</form>

<!-- table.html -->
<table>
  <thead>
    <tr>
      <th>姓名</th>
      <th>年龄</th>
    </4>
  </thead>
  <tbody>
    {% for person in persons %}
      <tr>
        <td>{{ person.name }}</td>
        <td>{{ person.age }}</td>
      </tr>
    {% endfor %}
  </tbody>
</table>

# urls.py
from django.urls import path
from . import views

urlpatterns = [
    path('upload/', views.upload_excel, name='upload_excel'),
    path('table/', views.table, name='table'),
]