Блог

 public List<List<string>> GetListFromExcel(string FileName)
{
    try
    {
        List<List<string>> sListOfRecords = new List<List<string>>();
        IExcelDataReader reader = null;
        using (var stream = System.IO.File.OpenRead(FileName))
        {
            string sExtension = Path.GetExtension(FileName);
            if (sExtension == ".xls")
            {
                reader = ExcelReaderFactory.CreateBinaryReader(stream);
            }
            else
            {
                reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
            }
            reader.IsFirstRowAsColumnNames = true;
            DataSet result = reader.AsDataSet();
            reader.Close();
            DataTable data = result.Tables[0];
            var excelColdata = new List<string>();
            foreach (DataRow row in data.Rows)
            {
                var excelRowdata = new List<string>();
                foreach (var item in row.ItemArray)
                {
                    excelRowdata.Add(item.ToString());
                }
                if (excelRowdata.Where(m => !string.IsNullOrWhiteSpace(m)).Count() > 0)
                {
                    sListOfRecords.Add(excelRowdata);
                }
            }
        }

        return sListOfRecords.Distinct().ToList();
    }
    catch (Exception ex)
    {
        ServiceUtil.LogError(ex);
        log.Error("Error", ex);
        throw ex;
    }

}