使用django-import-export创建Excel导入接口遇报错求助

Hey there! Let's work through this Excel import issue with django-import-export together. Based on what you've described, here are the most likely fixes and troubleshooting steps:

Tablib needs extra libraries to handle Excel files, and missing these is one of the most common causes of loading errors:

• For .xlsx files: Install openpyxl
• For older .xls files: Install xlrd (note: xlrd v2.0+ only supports .xls; use openpyxl for .xlsx if you're on a newer xlrd version)

Run this command to get both:

pip install openpyxl xlrd

In Django, uploaded files are InMemoryUploadedFile or TemporaryUploadedFile objects—you can't just pass the filename to Dataset.load(). Here's the right way to process the file:

Avoid this common mistake: #

# ❌ Wrong: Using the filename instead of the file content
dataset = Dataset().load(request.FILES['excel_file'].name)

Do this instead: #

from tablib import Dataset

def upload_view(request):
    if request.method == 'POST':
        excel_file = request.FILES['excel_file']
        try:
            # Read the file content directly and specify the format
            dataset = Dataset().load(excel_file.read(), format='xlsx')
            # If you're using .xls, change format to 'xls'
        except Exception as e:
            # Capture and log the exact error to debug
            print(f"Dataset load error: {str(e)}")
            # Return this error to your frontend for visibility

Since you're using django-import-export, leverage its ModelResource class to handle the import—it simplifies the process and reduces manual errors. Let's assume your ItemImportModel is set up; first define a resource:

# in your app's resources.py
from import_export import resources
from .models import ItemImportModel

class ItemImportResource(resources.ModelResource):
    class Meta:
        model = ItemImportModel
        # Optional: Specify fields if you don't want to import all model fields
        # fields = ('name', 'quantity', 'price')

Then use this resource in your view to handle the upload:

from .resources import ItemImportResource

def upload_view(request):
    if request.method == 'POST':
        excel_file = request.FILES['excel_file']
        resource = ItemImportResource()
        
        # Import the data directly from the uploaded file
        result = resource.import_data(
            excel_file,
            format='xlsx',  # Match your file format
            dry_run=False,  # Set to True first to test without saving to DB
            raise_errors=True  # Optional: Raise exceptions to debug
        )
        
        # Check for import errors
        if result.has_errors():
            # Access invalid rows and error messages
            for row in result.invalid_rows:
                print(f"Row {row.number}: {row.error}")
            # Return error feedback to the user
        else:
            # Import successful!
            return HttpResponse("Excel data imported successfully")

• "No format found for 'xlsx'": This means openpyxl isn't installed—run pip install openpyxl to fix it.
• File corruption or format mismatch: Ensure the uploaded file is a valid Excel file (not a CSV renamed to .xlsx).
• Header mismatch: Make sure the Excel's first row (headers) exactly matches your model's field names (or the names defined in your ModelResource).
• Large file issues: If uploading big files, adjust Django's upload limits in settings.py:

  FILE_UPLOAD_MAX_MEMORY_SIZE = 10485760  # 10MB (adjust as needed)
  

If you're still getting errors, wrap the import code in a try-except block to capture the full error traceback. This will tell you exactly what's going wrong—whether it's a data type mismatch, missing fields, or file handling issues.

内容的提问来源于stack exchange，提问作者user2880391