So I found a useful Package to read excel files easily. No more cumbersome codes needed.
I have written post on How to read Excel file in c# in here . But lot of codes.
So I found ExcelDataReader package in github.
It is awesome.
Just few lines of codes to read files as below.
string filePath = "Book1.xlsx"; FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); excelReader.IsFirstRowAsColumnNames = true; DataSet result = excelReader.AsDataSet(); excelReader.Close();
done.