使用xlsxwriter将CSV转换为excel并保存到django模型

pip install xlsxwriter

import csv
import io
import xlsxwriter

from django.core.files.base import ContentFile
from .models import MyModel

def convert_csv_to_excel(csv_file, model_instance):
    # 读取CSV文件
    csv_data = csv.reader(csv_file)

    # 创建一个内存中的Excel文件
    output = io.BytesIO()
    workbook = xlsxwriter.Workbook(output)
    worksheet = workbook.add_worksheet()

    # 写入CSV数据到Excel文件
    for row_index, row in enumerate(csv_data):
        for col_index, value in enumerate(row):
            worksheet.write(row_index, col_index, value)

    # 关闭Excel文件
    workbook.close()

    # 将Excel文件保存到Django模型
    model_instance.excel_file.save('converted_excel.xlsx', ContentFile(output.getvalue()), save=False)
    model_instance.save()

csv_file = open('input.csv', 'r')
model_instance = MyModel()
convert_csv_to_excel(csv_file, model_instance)