Django后台导入Excel后页面刷新无提示问题求助

我正在开发基于Django的Web应用，自定义了RMABGD模型的Admin视图，制作了添加页自定义模板，并重写了save_model方法处理Excel导入。但点击"Import Excel"按钮后，页面仅刷新无任何提示，文件处理函数好像没执行，求排查问题。

RMABGD Admin类代码 #

@admin.register(RMABGD)
class RMABGDAdmin(BaseModelAdmin):
    list_display = ('name', 'code_RMA', 'type_BGD', 'Partenaire', 'date_creation', 'RMA_BGD_state')
    list_filter = ('type_BGD', 'RMA_BGD_state', 'city')
    search_fields = ('name', 'code_RMA', 'Partenaire')

    add_form_template = "admin/spatial_data/RMABGD/change_form.html"
    change_form_template = "admin/spatial_data/RMABGD/change_form.html"

    def process_excel_import(self, request):
        excel_file = request.FILES.get('excel_file')
        if not excel_file:
            messages.error(request, "No file was selected. Please choose an Excel file.")
            return False
        try:
            df = pd.read_excel(excel_file)

            required_headers = ["code RMA", "code ACAPS", "Dénomination RMA", "Ville", "Adresse", "Longitude", "Latitude", "Type BGD", "Partenaire", "Date création", "Etat BGD RMA"]
            missing_headers = [header for header in required_headers if header not in df.columns]

            if missing_headers:
                messages.error(request, f"Missing required fields: {', '.join(missing_headers)}")
                return False
            else:
                # If all headers are correct, process data
                rows_imported = 0
                errors = 0
                for index, row in df.iterrows():
                    try:
                        # Process row data
                        obj = RMABGD(
                            code_ACAPS=row["code ACAPS"],
                            code_RMA=row["code RMA"],
                            name=row["Dénomination RMA"],
                            address=row["Adresse"],
                            city=row["Ville"],
                            location=f'POINT({row["Longitude"]} {row["Latitude"]})',
                            type_BGD=row["Type BGD"],
                            Partenaire=row["Partenaire"],
                            date_creation=row["Date création"],
                            RMA_BGD_state=row["Etat BGD RMA"]
                        )
                        obj.save()
                        rows_imported += 1
                    except Exception as e:
                        messages.error(request, f"Error in row {index + 1}: {str(e)}")
                        errors += 1

                if rows_imported > 0:
                    messages.success(request, f"Successfully imported {rows_imported} rows")
                    return True
                if errors > 0:
                    messages.warning(request, f"Failed to import {errors} rows. See details above.")
                if rows_imported == 0:
                    messages.error(request, "No rows were imported. Please check your file and try again.")
                return rows_imported > 0
        except Exception as e:
            messages.error(request, f"Error processing file: {str(e)}")
            return False
    
    def save_model(self, request, obj, form, change):
        self.process_excel_import(request)
        super().save_model(request, obj, form, change)

自定义添加页模板代码 #

{% extends "admin/base_site.html" %}
{% load i18n admin_urls static %}

{% block content %}
<div id="content-main">
    {% if messages %}
    <ul class="messagelist">
        {% for message in messages %}
        <li{% if message.tags %} class="{{ message.tags }}"{% endif %}>{{ message }}</li>
        {% endfor %}
    </ul>
    {% endif %}

    <form action="." method="post" enctype="multipart/form-data">
        {% csrf_token %}
        <div>
            <fieldset class="module aligned">
                <div class="form-row">
                    <div class="fieldBox">
                        <label for="id_excel_file" class="required">Excel File:</label>
                        <input type="file" name="excel_file" id="id_excel_file" accept=".xlsx,.xls" required>
                        <div class="help">Upload an Excel file with the required columns</div>
                    </div>
                </div>
            </fieldset>

            <div class="help-text">
                <p><strong>{% trans 'Required fields in the imported file:' %}</strong></p>
                <ul>
                    <li>code RMA</li>
                    <li>code ACAPS</li>
                    <li>Dénomination RMA</li>
                    <li>Ville</li>
                    <li>Adresse</li>
                    <li>Longitude</li>
                    <li>Latitude</li>
                    <li>Type BGD</li>
                    <li>Partenaire</li>
                    <li>Date création</li>
                    <li>Etat BGD RMA</li>
                </ul>
            </div>

            <div class="submit-row">
                <input type="submit" value="{% trans 'Import Excel' %}" class="default" name="_import_file">
            </div>
        </div>
    </form>
</div>
{% endblock %}

问题排查与修复 #

1. save_model执行时机不匹配 #

默认情况下，Django Admin的save_model只有在表单验证通过且有模型实例需要保存时才会触发。但你的自定义模板没有渲染默认模型表单字段，提交时无模型数据，导致save_model可能未被调用，或调用时逻辑异常。

修复方法：重写add_view方法处理导入请求，替代save_model：

def add_view(self, request, form_url='', extra_context=None):
    if request.method == 'POST' and '_import_file' in request.POST:
        # 处理Excel导入
        self.process_excel_import(request)
        # 重定向保留消息
        return redirect(request.path)
    # 调用默认添加页逻辑
    return super().add_view(request, form_url, extra_context)

2. 消息框架配置缺失 #

确保项目settings.py中启用消息相关组件：

MIDDLEWARE = [
    # ... 其他中间件
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    # ...
]

INSTALLED_APPS = [
    # ...
    'django.contrib.messages',
    # ...
]

# 默认消息存储即可
MESSAGE_STORAGE = 'django.contrib.messages.storage.session.SessionStorage'

3. 调试确认函数执行状态 #

在process_excel_import的最外层异常捕获中添加日志/打印，确认函数是否被执行：

except Exception as e:
    print(f"Excel处理错误: {str(e)}")  # 临时调试
    messages.error(request, f"Error processing file: {str(e)}")
    return False

4. 确保消息保留 #

处理完导入后必须通过redirect跳转，否则消息会在刷新后丢失，上述add_view修复已包含此逻辑。

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