I was trying to use excelreader. But all the columnnames don't get read and the data is empty as well. Below is my (simple) code
//create a reader
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
//...
//4. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet dataSet = excelReader.AsDataSet();