使用JavaScriptSerializer将CSV转换为JSON

thatOneGuy 发表于 Dev

那一个人

我正在使用以下代码通过C＃将csv转换为json：

var jsonWrtr = new StreamWriter(targetFile + ".json");

var csv = new List<string[]>(); // or, List<YourClass>
var lines = System.IO.File.ReadAllLines(targetFile + ".csv");                    

foreach (string line in lines) {  csv.Add(line.Split(','));  } 
string json = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(csv);  
jsonWrtr.Write(json);
jsonWrtr.Close();

这是它输出的示例：

[["Type","Id","Name","Age","Org","DOB","FirstName","LastName","Flight"],["1","2","3","4","5","6","7","8","9"],["1","2","3","4","5","6","7","8","9"]]

我想要以下格式的输出：

[{
        "Type" : "1",
        "Id" : "2",
        "Name" : "3",
        "Age" : "4",
        "Org" : "5",
        "Dob" : "6", ,
        "FirstName" : "7",
        "LastName" : "8",
        "Flight" : "9",
    }, {
        "Type" : "1",
        "Id" : "2",
        "Name" : "3",
        "Age" : "4",
        "Org" : "5",
        "Dob" : "6", ,
        "FirstName" : "7",
        "LastName" : "8",
        "Flight" : "9",
    }
]

任何想法为什么它不起作用？

塔玛斯·赫格杜斯（Tamas Hegedus）

代码产生的输出是预期的输出。您必须将数据转换为所需的格式。这是一个示例如何执行此操作：

static void Main(string[] args)
{
    var lines = @"A,B,C
1,2,3
4,5,6".Replace("\r", "").Split('\n');

    var csv = lines.Select(l => l.Split(',')).ToList();

    var headers = csv[0];
    var dicts = csv.Skip(1).Select(row => Enumerable.Zip(headers, row, Tuple.Create).ToDictionary(p => p.Item1, p => p.Item2)).ToArray();

    string json = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(dicts);
    Console.WriteLine(json);
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。