如何将csv文件作为Json数据加载到MVC web应用程序中。标头可以不同

import csv
import json

csv_file_path = 'path_to_your_csv_file.csv'
json_file_path = 'path_to_save_json_file.json'

data = []
with open(csv_file_path, 'r') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    for row in csv_reader:
        data.append(row)

with open(json_file_path, 'w') as json_file:
    json.dump(data, json_file)

using System.IO;
using System.Web.Mvc;
using Newtonsoft.Json;

public class HomeController : Controller
{
    public ActionResult Index()
    {
        string jsonFilePath = "path_to_your_json_file.json";
        string jsonData = System.IO.File.ReadAllText(jsonFilePath);
        var model = JsonConvert.DeserializeObject(jsonData);

        return View(model);
    }
}

@model YourModelType

<table>
    <thead>
        <tr>
            <th>Column 1</th>
            <th>Column 2</th>
            <th>Column 3</th>
            <!-- 添加更多列 -->
        </tr>
    </thead>
    <tbody>
        @foreach (var item in Model)
        {
            <tr>
                <td>@item.Column1</td>
                <td>@item.Column2</td>
                <td>@item.Column3</td>
                <!-- 添加更多列 -->
            </tr>
        }
    </tbody>
</table>