以父子格式将excel数据导入django数据库

import openpyxl
from django.core.management.base import BaseCommand
from myapp.models import ParentModel, ChildModel

class Command(BaseCommand):
    help = 'Import Excel data into Django database'

    def add_arguments(self, parser):
        parser.add_argument('file_path', type=str, help='Path to Excel file')

    def handle(self, *args, **options):
        file_path = options['file_path']
        wb = openpyxl.load_workbook(file_path)
        sheet = wb.active

        for row in sheet.iter_rows(min_row=2):
            parent_data = {
                'name': row[0].value,
                'age': row[1].value,
                # Add other parent model fields
            }
            parent = ParentModel.objects.create(**parent_data)

            child_data = {
                'name': row[2].value,
                'grade': row[3].value,
                'parent': parent,
                # Add other child model fields
            }
            ChildModel.objects.create(**child_data)

        self.stdout.write(self.style.SUCCESS('Data imported successfully.'))

python manage.py import_excel_data /path/to/excel/file.xlsx