ExcelEnumerable 1.0.0

ExcelEnumerable

ExcelDataReader wrapper for supporting LINQ while reading excel files.

Motivation

The project has been created in order to enable easy way to use C# LINQ while reading from excel files.

Usage

Install a NuGet package ExcelEnumerable, then create a class that represents row with column names which you want to fetch from excel file. You can use XcelEnumerableColumnAttribute to specify name of the column when the property name cannot match it:

public class SampleRow
{
  public string Email { get; set; }
  
  [XcelEnumerableColumn("First Name")]
  public string FirstName { get; set; } 
}

Create a new instance of XcelEnumerable by using XcelEnumerableFactory, and specifying the previously created type, which represents the row in excel file, as an argument of generic Create method, and passing Stream or file path:

using(var excelEnumerable = XcelEnumerableFactory.Create<SampleRow>(stream); // or .Create<SampleRow>(fileName))
{
  ...
}

Query excel files by applying LINQ expressions:

var filteredRows = excelEnumerable.Where(r => r.Email.Contains("domain.com")).ToList();

Important when targeting .NET Core Application

When targeting .NET Core, it's important to add dependency on System.Text.Encoding.CodePages and register the code page provider during application initialization:

System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);