Save object list to csv c# asp.net

Question

I want to return a csv file to a website from an object list.

The process starts with retrieving json data from a database, convert it to a list of objects and print it to a csv file. I currently have no idea to how I should return the file, currently I save it to my own hdd (just to make sure it works like I wanted it to).

Class for the function to write the csv:

public void WriteCSV<T>(IEnumerable<T> items, string path)
{
    Type itemType = typeof(T);
    var props = itemType.GetProperties(BindingFlags.Public |
    BindingFlags.Instance)
                        .OrderBy(p => p.Name);

    using (var writer = new StreamWriter(path))
    {
        writer.WriteLine("sep=,");
        writer.WriteLine(string.Join(", ", props.Select(p => p.Name)));

        foreach (var item in items)
        {
            writer.WriteLine(string.Join(", ", props.Select(p =>
            p.GetValue(item, null))));
        }
    }
}

Class to call the method and runt the file to the user:

public List<jsonObj> dataList = new List<jsonObj>();
[HttpGet]
[Route("api/csv/{id}")]
public IActionResult getCsv(int id)
{

    var client = new HttpClient();

    var json = client.GetStringAsync("http://localhost:52716/api/csv/data/" + id).Result;

    dataList = JsonConvert.DeserializeObject<List<jsonObj>>(json);


    WriteCSV(dataList, @"C:\Users\****\Desktop\min.csv");
    return Ok();
    //return File(csv, "text /csv", "results.csv");
}

You might want to use a specialized library for creating CSV: joshclose.github.io/CsvHelper — VDWWD
– VDWWD, Commented Mar 10, 2018 at 10:11
For asp.net core see stackoverflow.com/questions/47423563/… — Ole EH Dufour
– Ole EH Dufour, Commented Mar 10, 2018 at 10:33
@OleEHDufour, Really? In your snippet you have to specify each columns separately and if you add a property you have to change string line = manually also. And what about error handling and escaping characters? Tested your snippet and it generates incorrect csv if the string has " in it. — VDWWD
– VDWWD, Commented Mar 10, 2018 at 10:35

VDWWD · Accepted Answer · 2018-03-10 10:37:50Z

Here a snippet with the library I mentioned. Just input MyList as your List with objects and you're done. Once you have a byte array you can send it to the browser, store it in the DB etc.

using CsvHelper;

byte[] bin;

using (MemoryStream stream = new MemoryStream())
using (TextWriter textWriter = new StreamWriter(stream))
using (CsvWriter csv = new CsvWriter(textWriter))
{
    csv.Configuration.QuoteAllFields = true;
    csv.Configuration.TrimHeaders = true;
    csv.Configuration.TrimFields = true;

    csv.WriteRecords(MyList);
    bin = stream.ToArray();
}

Response.ClearHeaders();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "text/csv; charset=utf-8";
Response.AppendHeader("Content-disposition", string.Format("attachment; filename=\"{0}\"", "MyFile.csv"));
Response.AppendHeader("Content-Length", bin.Length.ToString());
Response.BinaryWrite(bin);
Response.Flush();
HttpContext.Current.ApplicationInstance.CompleteRequest();

Collectives™ on Stack Overflow

Save object list to csv c# asp.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related