How to read CSV file !

Abdalla Omran

Hi there

i would like to read the CSV file holding some data about temp for example i would like to read the data actual mean temp, actual min temp and so on but the problem i am faceing that the data is not clear i can not read it well here an Example :

date,actual_mean_temp,actual_min_temp,actual_max_temp,average_min_temp,average_max_temp,record_min_temp,record_max_temp

2014-7-1,76,66,86,66,85,48,97,1885,1970,0.13,0.16,5.09

2014-7-2,71,63,79,66,85,50,99,1904,1970,0.00,0.16,4.50

2014-7-3,67,60,73,66,85,49,100,1968,1911,0.0,0.15,1.89

if i open it as txt its the same problem thus the Question if i can read it like this or spilting with comma ?

for any idea i will be so happy

thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

7y ago
Accepted answer
For .net you can user free nuget tool Install-Package LumenWorksCsvReader

Site: https://www.nuget.org/packages/LumenWorksCsvReader/

it will available on .net mvc and core

after installing nuger package, write below code to get data from csv file

var csvTable = new DataTable();

using (var csvReader =new CsvReader(new StreamReader(System.IO.File.OpenRead("filepath")),true))

{

csvTable.Load(csvReader); // load all data in DataTable

}
Leon D7y ago
You can use free spire.xls library from nuget and the below code to easily read csv file.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\csvtodatatable.csv", ",");

Worksheet worksheet = workbook.Worksheets[0];
DataTable dt = worksheet.ExportDataTable();
//....
Abdalla Omran7y ago
Dhrumit Patel

what if i need to add it in a list then return an instance from the list ?
Amit Gupta7y ago
No need to use linq. Look at this https://www.c-sharpcorner.com/article/how-to-upload-browse-and-show-csv-file-information-in-asp-net-gridview/
Abdalla Omran7y ago
Amit Gupta,

do you have any idea how could i make it with the best way without using LINQ ?
Amit Gupta7y ago
CSV stands for Comma Seperated Value that means the data is separated with comma. You have to do that way.