CsvHelper.Excel.Core 15.0.5

.NET Standard 2.0
There is a newer version of this package available.
See the version list below for details.
NuGet\Install-Package CsvHelper.Excel.Core -Version 15.0.5
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
dotnet add package CsvHelper.Excel.Core --version 15.0.5
<PackageReference Include="CsvHelper.Excel.Core" Version="15.0.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CsvHelper.Excel.Core --version 15.0.5
#r "nuget: CsvHelper.Excel.Core, 15.0.5"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install CsvHelper.Excel.Core as a Cake Addin
#addin nuget:?package=CsvHelper.Excel.Core&version=15.0.5

// Install CsvHelper.Excel.Core as a Cake Tool
#tool nuget:?package=CsvHelper.Excel.Core&version=15.0.5

Discord Chat NuGet Badge

Csv Helper for Excel

CsvHelper for Excel is an extension that links 2 excellent libraries, CsvHelper and ClosedXml. It provides an implementation of ICsvParser and ICsvSerializer from CsvHelper that read and write to Excel using ClosedXml.

ExcelParser

ExcelParser implements IParser and allows you to specify the path of the workbook or a stream.

When the path is passed to the constructor then the workbook loading and disposal is handled by the parser. By default the first worksheet is used as the data source.

using var reader = new CsvReader(new ExcelParser("path/to/file.xlsx"));
var people = reader.GetRecords<Person>();

When an instance of stream is passed to the constructor then disposal will not be handled by the parser. By default the first worksheet is used as the data source.


var bytes = File.ReadAllBytes("path/to/file.xlsx");

using var stream = new MemoryStream(bytes);
using var parser = new ExcelParser(stream);
using var reader = new CsvReader(parser);

var people = reader.GetRecords<Person>();
// do other stuff with workbook

All constructor options have overloads allowing you to specify your own CsvConfiguration, otherwise the default is used.

ExcelSerializer

ExcelSerializer implements ISerializer and, like ExcelParser, allows you to specify the path to which to (eventually) save the workbook or a stream.

When the path is passed to the constructor the creation and disposal of both the workbook and worksheet (defaultly named "Export") as well as the saving of the workbook on dispose, is handled by the serialiser.

using (var writer = new CsvWriter(new ExcelSerializer("path/to/file.xlsx")))
{
    writer.WriteRecords(people);
}

When an instance of stream is passed to the constructor the creation and disposal of a new worksheet (defaultly named "Export") is handled by the serialiser, but the workbook will not be saved.


using var stream = new MemoryStream();
using var serialiser = new ExcelParser(stream);
using var writer = new CsvWriter(serialiser);
writer.WriteRecords(people);
//other stuff
var bytes = stream.ToArray();

All constructor options have overloads allowing you to specify your own CsvConfiguration, otherwise the default is used.

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on CsvHelper.Excel.Core:

Package Downloads
NiuX.Common

csharp common, utils, helpers, tools etc.

NiuX.Tools

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
27.2.1 61,553 1/7/2022
27.2.1-beta0014 83 1/7/2022
27.2.1-beta0013 77 1/7/2022
22.1.1 85,989 2/9/2021
22.1.1-beta0014 103 1/7/2022
22.1.1-beta0013 98 1/7/2022
22.1.1-beta0010 93 1/7/2022
22.1.1-beta0009 96 1/7/2022
22.1.1-beta0008 96 1/7/2022
15.0.5 47,388 8/13/2020
15.0.0 24,541 2/12/2020