A simple C# class library which is lightweight and open source that can read the data in CSV format from text files and strings is called CSV Reader in C# whose latest version must be downloaded and included in the project we are creating as a compiled DLL or as a source and it builds itself in all the versions of Microsoft visual studio 2008 or CSVReader.cs and StringConverter.cs can be downloaded to include the CSV Reader directly in our source code which can be added to the C# project we are doing on Microsoft Visual Studio and CSV Reader class belongs to DataSreams.csv namespace.
The syntax of C# CSV Reader is as follows:
public sealed class CsvReader : ReaderBase
Here are the following examples mention below
Program to demonstrate CSV Reader in a program to read the contents of a CSV file
Code:
using System;
using System.Diagnostics;
using System.IO;
using Microsoft.VisualBasic.FileIO;
//a class called check is defined
class check
{
//an array of strings is defined to store the values from the csv file as an array
List<string[]> records = new List<string[]>();
//an instance of csv reader class is created by giving the path of the csv file
using (CsvReader reader = new CsvReader("C:\\Users\\admin\\Desktop\\imp.csv", Encoding.Default))
{
//the csv file is read until the last record is reached by making use of fields’ property
while (reader.ReadNextRecord())
//adding the records from the read csv file to the array
records.Add(reader.Fields);
}
//displaying the contents of the array
foreach (var array in records)
{
Console.WriteLine("{0}", array);
}
}Output:
In the above program, a class called check is defined. Then an array of strings is defined to store the values from the csv file as an array. Then an instance of csv reader class is created by giving the path of the csv file. Then the records are read from the csv file until the last record is reached by making use of fields’ property and then the read records are added to the array by using the Add method. Then the contents of the array is displayed. The output is as shown above.
Note: Please save the input file in .csv format before providing the path of the file as input to the program.Program to demonstrate CSV Reader in a program to read the contents of a CSV file
Code:
using System;
using System.Diagnostics;
using System.IO;
using Microsoft.VisualBasic.FileIO;
//a class called check is defined
class check
{
//an array of integers is defined to store the values from the csv file as an array
List<int[]> records = new List<int[]>();
//an instance of csv reader class is created by giving the path of the csv file
using (CsvReader reader = new CsvReader("C:\\Users\\admin\\Desktop\\imp1.csv", Encoding.Default))
{
//the csv file is read until the last record is reached by making use of fields’ property
while (reader.ReadNextRecord())
//adding the records from the read csv file to the array
records.Add(reader.Fields);
}
//displaying the contents of the array
foreach (var array in records)
{
Console.WriteLine("{0}", array);
}
}Output:
In the above program, a class called check is defined. Then an array of strings is defined to store the values from the csv file as an array. Then an instance of csv reader class is created by giving the path of the csv file. Then the records are read from the csv file until the last record is reached by making use of fields’ property and then the read records are added to the array by using the Add method. Then the contents of the array is displayed. The output is as shown above.
Note: Please save the input file in .csv format before providing the path of the file as input to the program.There are several advantages of using CSV Reader. They are:
In this tutorial, we understand the concept of CSV Reader in C# through definition, syntax, and working of CSV Reader through programming examples and their outputs and the advantages of using CSV Reader in our program to read a file in CSV format.
以上是C# CSV 閱讀器的詳細內容。更多資訊請關注PHP中文網其他相關文章！
