如何创建带多选项的提交按钮以修改CSV并提交至Django表单

我需要为特定用户的文件列表创建带有下拉操作选项的提交按钮，目前已实现下载CSV文件、修改内容并保存为新文件的功能，但无法将新生成的newFile.csv重新提交并添加到文件列表中，卡在如何将该文件传入DocumentForm(request.POST, request.FILES)这一步。

现有代码 #

models.py #

class Document(models.Model):
     user = models.ForeignKey(User, blank=True, null=True, on_delete=models.CASCADE)
     description = models.CharField(max_length=255, blank=False)
     document = models.FileField(upload_to=fileLocation)
     uploaded_at = models.DateTimeField(auto_now_add=True)

forms.py #

class DocumentForm(forms.ModelForm):
    class Meta:
        model = Document
        fields = ('description', 'document')

HTML模板 #

{% for file in files %}
<form id="file-{{ file.id }}" action="{% url 'process' %}" method="post" enctype="multipart/form-data">
    {% csrf_token %}
    <select name="selectedOption"> 
        <option value="1">操作1</option>
        <option value="2">操作2</option>
        <option value="3">操作3</option>
    </select>
    <input type="submit" value="提交" class="btn btn-sm">
</form>
{% endfor %}

views.py（原代码） #

def process(request):
     selected_option = request.POST.get('selectedOption')

     form = DocumentForm(request.POST, request.FILES)
     current_client = request.user
     files = Document.objects.filter(user=current_client)

     fileResponse = s3_client.get_object(Bucket=settings.AWS_STORAGE_BUCKET_NAME, Key=document)
     df = pd.read_csv(fileResponse.get("Body"), encoding='utf-8', dtype=str)
     df.to_csv('temp/temp.csv', index=False, header=True, encoding='utf-8-sig')
    newFile = 'temp/temp.csv'

if request.method == 'POST':
    form = DocumentForm(request.POST, request.FILES)
    if form.is_valid():
        instance = form.save(commit=False)
        instance.user = request.user
        instance.save()
        return redirect('/filelist')
else:
    form = DocumentForm()

return render(request, 'accounts/filelist.html', {'selected_option':selected_option, 'form': form, 'files': files})

解决方案 #

1. 修正HTML表单，传递待处理文件ID #

原表单未传递当前要处理的文件ID，导致后端无法确定操作对象。添加隐藏字段file_id，将循环中的文件ID传给后端：

{% for file in files %}
<form id="file-{{ file.id }}" action="{% url 'process' %}" method="post" enctype="multipart/form-data">
    {% csrf_token %}
    <input type="hidden" name="file_id" value="{{ file.id }}">
    <select name="selectedOption"> 
        <option value="1">操作1</option>
        <option value="2">操作2</option>
        <option value="3">操作3</option>
    </select>
    <input type="submit" value="提交" class="btn btn-sm">
</form>
{% endfor %}

2. 调整views.py逻辑，包装生成的文件为InMemoryUploadedFile #

Django的DocumentForm仅识别request.FILES中的标准文件对象，本地生成的文件需要转换为InMemoryUploadedFile格式才能被表单处理。修改后的views.py代码：

import os
from io import BytesIO
from django.core.files.uploadedfile import InMemoryUploadedFile
import pandas as pd

def process(request):
    current_client = request.user
    files = Document.objects.filter(user=current_client)
    selected_option = request.POST.get('selectedOption')

    if request.method == 'POST':
        # 获取待处理文件ID
        file_id = request.POST.get('file_id')
        if not file_id:
            return render(request, 'accounts/filelist.html', {'files': files, 'error': '未选择目标文件'})
        
        try:
            target_file = Document.objects.get(id=file_id, user=current_client)
        except Document.DoesNotExist:
            return render(request, 'accounts/filelist.html', {'files': files, 'error': '目标文件不存在'})
        
        # 从S3下载文件并处理
        fileResponse = s3_client.get_object(Bucket=settings.AWS_STORAGE_BUCKET_NAME, Key=target_file.document.name)
        df = pd.read_csv(fileResponse.get("Body"), encoding='utf-8', dtype=str)
        
        # 根据选中选项执行数据处理（示例逻辑，需替换为实际需求）
        if selected_option == '1':
            df['新增列'] = '默认值'
        elif selected_option == '2':
            df = df.dropna()
        elif selected_option == '3':
            df = df.rename(columns={'原列名': '新列名'})
        
        # 将处理后的数据存入内存，模拟上传文件
        output = BytesIO()
        df.to_csv(output, index=False, header=True, encoding='utf-8-sig')
        output.seek(0)
        
        # 创建符合表单要求的文件对象
        new_file = InMemoryUploadedFile(
            output,
            'document',
            f"处理后_{os.path.basename(target_file.document.name)}",
            'text/csv',
            output.getbuffer().nbytes,
            None
        )
        
        # 构造表单数据并验证保存
        form_data = {
            'description': f"操作{selected_option}处理后的文件",
            'document': new_file
        }
        form = DocumentForm(form_data, {'document': new_file})
        
        if form.is_valid():
            instance = form.save(commit=False)
            instance.user = current_client
            instance.save()
            return redirect('/filelist')
        else:
            return render(request, 'accounts/filelist.html', {'files': files, 'form_errors': form.errors})
    else:
        form = DocumentForm()
    
    return render(request, 'accounts/filelist.html', {'selected_option': selected_option, 'form': form, 'files': files})

3. 关键说明 #

• 文件格式转换：通过BytesIO将DataFrame输出存入内存，再包装为InMemoryUploadedFile，让后端将其识别为用户上传的文件。
• 表单数据构造：手动传入data和files参数，其中files字典的键需与DocumentForm中的document字段对应。
• 逻辑顺序优化：将文件处理逻辑放在POST请求判断内部，避免无效执行；同时通过文件ID校验确保操作的是当前用户的文件。

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