如何将数据从超文本标记语言表格导入DJango

from bs4 import BeautifulSoup
from django import forms
from django.db import models

# 定义Django模型
class MyModel(models.Model):
    field1 = models.CharField(max_length=100)
    field2 = models.IntegerField()

# 定义Django表单
class MyForm(forms.ModelForm):
    class Meta:
        model = MyModel
        fields = ['field1', 'field2']

# 解析HTML表格数据
html = """
<table>
  <tr>
    <th>Field 1</th>
    <th>Field 2</th>
  </tr>
  <tr>
    <td>Value 1</td>
    <td>Value 2</td>
  </tr>
</table>
"""
soup = BeautifulSoup(html, 'html.parser')
table = soup.find('table')

# 提取表格数据
data = []
for row in table.find_all('tr'):
    cells = row.find_all('td')
    if cells:
        data.append({
            'field1': cells[0].text,
            'field2': int(cells[1].text)
        })

# 创建Django表单实例
form = MyForm()

# 验证和保存数据
for item in data:
    form = MyForm(item)
    if form.is_valid():
        form.save()