Exceader 1.0.0

Lightweight Excel data reader.

Install-Package Exceader -Version 1.0.0
dotnet add package Exceader --version 1.0.0
<PackageReference Include="Exceader" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Exceader --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Exceader

Exceader is a lightweight Excel data reader.

Features:

  • Simple and intuitive APIs
  • Less dependencies

Supported formats

This software supports only Excel 2007 or later format (*.xlsx) currently.

Usage

Get a cell value

You can get a cell value by the index or Excell's number.

using (var book = Book.Open("/path/to/file"))
{
    var sheet = book["sheet name"];

    // by index
    var a1 = sheet[0, 0].Value;
    var b2 = sheet[1][1].Value;

    // by Excel's number
    var c3 = sheet["C3"].Value;
    var d4 = sheet[3]["D"].Value;

    // Get a value as other types
    var @int = sheet["A1"].AsInteger();
    var @float = sheet["A1"].AsFloat();
    var @double = sheet["A1"].AsDouble();
    var dt1 = sheet["A1"].AsDateTime();
    var dt2 = sheet["A1"].AsDateTime("yyyy/MM/dd");
}

Iteration

In Exceader, row and column has infinity length (actually int.MaxLength). So you need to specify the range to read for iteration.

using (var book = Book.Open("/path/to/file"))
{
    var sheet = book["sheet name"];

    foreach (var row in sheet.Range(0, 16))
    {
        // by column index
        foreach (var cell in row.Range(2, 8))
        {
            var columnIndex = cell.Index;
        }

        // by column name
        foreach (var cell in row.Range("C", "I"))
        {
            var columnName = cell.ColumnName;
        }
    }
}

Installation

You can install via NuGet.

PM> Install-Package Exceader

Author

  • akiqsinco (<akiqsinco@gmail.com>)

Copyright

Copyright (c) 2019 akiqsinco (<akiqsinco@gmail.com>)

License

This software is released under the MIT License, see LICENSE.txt.

Exceader

Exceader is a lightweight Excel data reader.

Features:

  • Simple and intuitive APIs
  • Less dependencies

Supported formats

This software supports only Excel 2007 or later format (*.xlsx) currently.

Usage

Get a cell value

You can get a cell value by the index or Excell's number.

using (var book = Book.Open("/path/to/file"))
{
    var sheet = book["sheet name"];

    // by index
    var a1 = sheet[0, 0].Value;
    var b2 = sheet[1][1].Value;

    // by Excel's number
    var c3 = sheet["C3"].Value;
    var d4 = sheet[3]["D"].Value;

    // Get a value as other types
    var @int = sheet["A1"].AsInteger();
    var @float = sheet["A1"].AsFloat();
    var @double = sheet["A1"].AsDouble();
    var dt1 = sheet["A1"].AsDateTime();
    var dt2 = sheet["A1"].AsDateTime("yyyy/MM/dd");
}

Iteration

In Exceader, row and column has infinity length (actually int.MaxLength). So you need to specify the range to read for iteration.

using (var book = Book.Open("/path/to/file"))
{
    var sheet = book["sheet name"];

    foreach (var row in sheet.Range(0, 16))
    {
        // by column index
        foreach (var cell in row.Range(2, 8))
        {
            var columnIndex = cell.Index;
        }

        // by column name
        foreach (var cell in row.Range("C", "I"))
        {
            var columnName = cell.ColumnName;
        }
    }
}

Installation

You can install via NuGet.

PM> Install-Package Exceader

Author

  • akiqsinco (<akiqsinco@gmail.com>)

Copyright

Copyright (c) 2019 akiqsinco (<akiqsinco@gmail.com>)

License

This software is released under the MIT License, see LICENSE.txt.

Release Notes

Initial release

  • .NETStandard 2.0

    • No dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.0 196 1/16/2019