JSON字符串到CSV和CSV到JSON转换在c＃ [英] JSON string to CSV and CSV to JSON conversion in c#

问题描述

我在asp.net网络API项目中使用JSON / CSV文件，并尝试使用

然后一些文件是分隔符类型，用逗号或制表符， CSVHelper 将CSV字符串动态转换为IEnumerable

  public static IEnumerable StringToList（string data，string delimiter，bool HasHeader）
 {
 using（var csv = new CsvReader（new StringReader（data）））
 {
 csv.Configuration.SkipEmptyRecords = true; 
 csv.Configuration.HasHeaderRecord = HasHeader; 
 csv.Configuration.Delimiter = delimiter; 
 
 var records = csv.GetRecords（）; 
返回记录; 
} 
} 
  

解决方案

I能够解决它的DeserializeObject到一个数据表使用Json.net，所以想发布自己的答案，但不会标记为接受，如果任何人有更好的方法来做到这一点。

将JSON字符串转换为DataTable

  public static DataTable jsonStringToTable（string jsonContent）
 {
 DataTable dt = JsonConvert.DeserializeObject< DataTable>（jsonContent）; 
 return dt; 
} 
  

制作CSV字符串 b
$ b

  public static string jsonToCSV（string jsonContent，string delimiter）
 {
 StringWriter csvString = new StringWriter 
 using（var csv = new CsvWriter（csvString））
 {
 csv.Configuration.SkipEmptyRecords = true; 
 csv.Configuration.WillThrowOnMissingField = false; 
 csv.Configuration.Delimiter = delimiter; 
 
使用（var dt = jsonStringToTable（jsonContent））
 {
 foreach（dt.Columns中的DataColumn列）
 {
 csv.WriteField .ColumnName）; 
} 
 csv.NextRecord（）; 
 
 foreach（dt.Rows中的DataRow行）
 {
 for（var i = 0; i  {
 csv.WriteField（row [i]）; 
} 
 csv.NextRecord（）; 
} 
} 
} 
 return csvString.ToString（）; 
} 
  

Web API中的最终用途

  string csv = jsonToCSV（content，，）; 
 
 HttpResponseMessage result = new HttpResponseMessage（HttpStatusCode.OK）; 
 result.Content = new StringContent（csv）; 
 result.Content.Headers.ContentType = new MediaTypeHeaderValue（text / csv）; 
 result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue（attachment）{FileName =export.csv}; 
 return result; 
  

I'm working with JSON/CSV files in my asp.net web API project and tried with CSVHelper and ServiceStack.Text libraries but couldn't make it work.

The JSON file containing an array is dynamic and may have any number of fields

I read the file using streamreader and then need to convert it into CSV file to make it downloadable for end users.

example file text

[{"COLUMN1":"a","COLUMN2":"b","COLUMN3":"c","COLUMN4":"d","COLUMN5":"e"},
 {"COLUMN1":"a","COLUMN2":"b","COLUMN3":"c","COLUMN4":"d","COLUMN5":"e"}]

JSON to CSV

public static string jsonStringToCSV(string content)
{
    var jsonContent = (JArray)JsonConvert.DeserializeObject(content);

    var csv = ServiceStack.Text.CsvSerializer.SerializeToCsv(jsonContent);
    return csv;
}

This doesn't result me CSV data

Then some files are delimiter type with comma or tab and and i want to utilize CSVHelper to convert CSV string to IEnumerable dynamically

public static IEnumerable StringToList(string data, string delimiter, bool HasHeader)
{
    using (var csv = new CsvReader(new StringReader(data)))
    {
         csv.Configuration.SkipEmptyRecords = true;
         csv.Configuration.HasHeaderRecord = HasHeader;
         csv.Configuration.Delimiter = delimiter;

         var records = csv.GetRecords();
         return records;
     }
}

解决方案

I was able to solve it by DeserializeObject to a datatable using Json.net, so want to post my own answer but will not mark it as accepted, if anyone have better way to do this.

To convert JSON string to DataTable

public static DataTable jsonStringToTable(string jsonContent)
        {
            DataTable dt = JsonConvert.DeserializeObject<DataTable>(jsonContent);
            return dt;
        }

To make CSV string

public static string jsonToCSV(string jsonContent, string delimiter)
        {
            StringWriter csvString = new StringWriter();
            using (var csv = new CsvWriter(csvString))
            {
                csv.Configuration.SkipEmptyRecords = true;
                csv.Configuration.WillThrowOnMissingField = false;
                csv.Configuration.Delimiter = delimiter;

                using (var dt = jsonStringToTable(jsonContent))
                {
                    foreach (DataColumn column in dt.Columns)
                    {
                        csv.WriteField(column.ColumnName);
                    }
                    csv.NextRecord();

                    foreach (DataRow row in dt.Rows)
                    {
                        for (var i = 0; i < dt.Columns.Count; i++)
                        {
                            csv.WriteField(row[i]);
                        }
                        csv.NextRecord();
                    }
                }
            }
            return csvString.ToString();
        }

Final Usage in Web API

string csv = jsonToCSV(content, ",");

                HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
                result.Content = new StringContent(csv);
                result.Content.Headers.ContentType = new MediaTypeHeaderValue("text/csv");
                result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = "export.csv" };
                return result;

这篇关于JSON字符串到CSV和CSV到JSON转换在c＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！