Ninjanaut.ExcelReader 1.0.0

Welcome to the ExcelReader project website! ExcelReader is lightweight C# library to ease loading data from Excel file into DataTable object, based on NPOI library.

Installation

from nuget package manager console

PM> Install-Package Ninjanaut.ExcelReader

from command line

> dotnet add package Ninjanaut.ExcelReader

Features

Usage

using Ninjanaut.IO;

var datatable = ExcelReader.ToDataTable(@"C:\FooExcel.xlsx");

or with options argument (the default settings)

using Ninjanaut.IO;

var datatable = ExcelReader.ToDataTable(@"C:\FooExcel.xlsx", new() {
                    Format = ExcelReaderFormat.Xlsx,
                    SheetIndex = 0,
                    SheetName = null,
                    HeaderRowIndex = 0,
                    RemoveEmptyRows = true,
                    AllowDuplicateColumns = true,
                    MaxColumns = null
                });

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.