Hi Mathi, try this;
IExcelDataReader iExcelDataReader = null;
FileStream oStream = File.Open(filepath, FileMode.Open, FileAccess.Read);
iExcelDataReader = ExcelReaderFactory.CreateOpenXmlReader(oStream);
iExcelDataReader.IsFirstRowAsColumnNames = true;
DataSet dsUnUpdated = new DataSet();
dsUnUpdated = iExcelDataReader.AsDataSet();
iExcelDataReader.Close();
if (dsUnUpdated == null)
{
oStream = File.Open(filepath, FileMode.Open, FileAccess.Read);
iExcelDataReader = ExcelReaderFactory.CreateBinaryReader(oStream);
iExcelDataReader.IsFirstRowAsColumnNames = true;
dsUnUpdated = iExcelDataReader.AsDataSet();
iExcelDataReader.Close();
}
you need to add Namespace for this;
using System.Runtime.Serialization.Formatters.Binary;
I hope this will help you.
Thank's
Mohan G