TableReader.ExcelDataReader 0.2.4

TableReader

Class library to read table.

ExcelTableReader

ExcelTableReader is a C# class library designed to easily read specified tables from Excel files. This library allows you to choose between two open-source libraries, ClosedXml or ExcelDataReader, depending on your environment. It supports both .NET Framework (4.7.2 and later) and .NET (8.0).

Features

• Flexible Library Selection: You can choose to use either ClosedXml or ExcelDataReader for handling Excel files.
  • Uses ClosedXml v0.97.0 for Excel file processing in .NET Framework environment.
  • Uses ExcelDataReader v3.6 for Excel file processing in .NET Framework environment,
• Multi-Environment Support: Compatible with both .NET Framework 4.7.2+ and .NET 8.0.
• Simple Interface: Easily read specified tables from Excel files.

Usage

Using ClosedXml (C#)

Here is an example of how to use TableReader.ClosedXml. The result is stored in the table variable, which is an instance of System.Data.DataTable from .NET Framework or .NET:

using System.Data;
using TableReader.ClosedXML;
using TableReader.Interface;

string testFilePath = "example.xlsx";
string sheetName = "Sheet1";
string tableName = "SampleTable"; // Specify the table name here

using var stream = new FileStream(testFilePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite) {
ITableReader reader = new ExcelTableReader(stream, sheetName);
DataTable table = reader.Read(tableName);

// Process the table data

Using ExcelDataReader (C#)

Similarly, using ExcelDataReader, the result is also stored in the table variable, which is an instance of System.Data.DataTable:

using System.Data;
using TableReader.ExcelDataReader;
using TableReader.Interface;

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

string testFilePath = "example.xlsx";
string sheetName = "Sheet1";
string tableName = "SampleTable"; // Specify the table name here

using var stream = new FileStream(testFilePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
ITableReader reader = new ExcelTableReader(stream, sheetName);
DataTable table = reader.Read(tableName);
// Process the table data

Exampels

This repository includes sample projects demonstrating the use of both TableReader.ClosedXml and TableReader.ExcelDataReader. Navigate to the Sample directory to see these examples.

License

This project is licensed under the MIT License. See the LICENSE file for details.