Using ExcelDataReader to read Excel data starting from a particular cell
If you are using ExcelDataReader 3+ you will find that there isn’t any method for AsDataSet() for your reader object, You need to also install another package for ExcelDataReader.DataSet, then you can use the AsDataSet() method. Also there is not a property for IsFirstRowAsColumnNames instead you need to set it inside of ExcelDataSetConfiguration. Example: using … Read more