If u want to read from .txt file then below code will help
public static DataTable exceldata(string filePath)
{
DataTable dtexcel = new DataTable();
var filename = filePath;
var reader = ReadAsLines(filename);
var headers = reader.First().Split('\t');
foreach (var header in headers)
{
dtexcel.Columns.Add(header);
}
var records = reader.Skip(1);
foreach (var record in records)
{
dtexcel.Rows.Add(record.Split('\t'));
}
}
static IEnumerable<string> ReadAsLines(string filename)
{
using (var reader = new StreamReader(filename))
while (!reader.EndOfStream)
yield return reader.ReadLine();
}