Ninjanaut.BinaryExcelReader 2.0.0

Welcome to the BinaryExcelReader project website! BinaryExcelReader is lightweight C# library to ease loading data from Excel binary (xlsb) file format into DataTable object, based on Microsoft OLE DB Driver. Also supports xls, xlsx and xlsm formats.

if you don't need to load .XLSB format, consider to use excel reader without OLE DB Driver dependency Ninjanaut.ExcelReader

Installation

from nuget package manager console

PM> Install-Package Ninjanaut.BinaryExcelReader

from command line

> dotnet add package Ninjanaut.BinaryExcelReader

Features

• Loading from file path via sheet name.
• Duplicate columns are implicitly allowed.
  • Columns A, B, B, B1 will be loaded as A, B, B1, B11 (this is OLE DB Driver default setting).
• Another options might be set via options parameter

Usage

using Ninjanaut.IO;

// From file path
var path = @"C:\FooExcel.xlsx";
var sheetName = "Sheet1"
var datatable = BinaryExcelReader.ToDataTable(path, sheetName);

you can also use options argument

using Ninjanaut.IO;

var path = @"C:\FooExcel.xlsx";
var sheetName = "Sheet1"
var options = new BinaryExcelReaderOptions 
{ 
    // Default settings:
    HeaderExists = true
    HeaderRowIndex = 0,
    RemoveEmptyRows = true,
    MaxColumns = null,
});

var datatable = BinaryExcelReader.ToDataTable(path, sheetName, options);

// The options may be defined within the method.
var datatable = ExcelReader.ToDataTable(path, sheetName, new() { MaxColumns = 5 });

Notes

DataTable object is suitable for this purpose, because you can easily view the read data directly in Visual Studio for debug purposes, create a collection of entities from it or pass datatable as parameter directly into the SQL server stored procedure.

Contribution

If you would like to contribute to the project, please send a pull request to the dev branch.