How to read csv from byte array?

kikme
kikme
248 Points
12 Posts

I have byte array of csv file data in memory. Want to parse and get all the data stored in it.

byte[] csvData = SomeMethod;

How to read csv from byte array?

Views: 2394
Total Answered: 1
Total Marked As Answer: 1
Posted On: 06-Jun-2023 04:48

Share:   fb twitter linkedin
Answers
beginer
beginer
1544 Points
52 Posts
         

Use CsvHelper package:

https://github.com/JoshClose/CsvHelper

And try following:

            byte[] csvData = new byte[32768];
            using (var fileReader = new StreamReader(new MemoryStream(csvData)))
            {
                var csvConfiguration = new CsvConfiguration(CultureInfo.CurrentCulture)
                {
                    Delimiter = ",",
                    HasHeaderRecord = false,
                };
                using (var csvReader = new CsvReader(fileReader, csvConfiguration))
                {
                    while (await csvReader.ReadAsync().ConfigureAwait(false))
                    {
                        var lineCsv = csvReader.GetRecord<dynamic>();
                    }
                }
            }

In the above example assumption that no header provided in the csv file data.

Need to import following package:

using CsvHelper.Configuration;
using System.Globalization;
using CsvHelper;
Posted On: 06-Jun-2023 22:44
Thanks
 - kikme  12-Jun-2023 01:55
 Log In to Chat