ExcelEnumerable 1.1.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 and specify the previously created type, which represents the row in an excel file, as a generic argument, passing stream or a file name to constructor:

using(var excelEnumerable = new XcelEnumerable<SampleRow>(stream)) // or new XcelEnumerable<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);