c#通过Linq表达式将excel数据转换成json

原创

已于 2022-12-26 16:25:16 修改 · 906 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#c# #json

于 2022-12-26 14:56:59 首次发布

1.首先读取本地excel文件,比如我的数据格式为

using (var reader = new StreamReader(@"d:\data.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
    var records = csv.GetRecords<model>().ToList();
    records.ForEach(p =>
    {
        if (string.IsNullOrWhiteSpace(p.image))
        {
            p.image = "connection.png";
        }
    }
 );

2. 通过Linq表达式拼接相应得json格式

var results = records.ToLookup(p => (string)p.shop_code, StringComparer.OrdinalIgnoreCase)
          .Select(g =>
              new
              {
                  topic = $"glkf:bu1:{g.Key.ToLower()}:devices",
                  ttl_sec = 0,
                  data = new
                  {
                      shop_code = g.Key.ToLower(),
                      shop_name = g.Key,