Excel.IO
0.8.0
dotnet add package Excel.IO --version 0.8.0
NuGet\Install-Package Excel.IO -Version 0.8.0
<PackageReference Include="Excel.IO" Version="0.8.0" />
paket add Excel.IO --version 0.8.0
#r "nuget: Excel.IO, 0.8.0"
// Install Excel.IO as a Cake Addin
#addin nuget:?package=Excel.IO&version=0.8.0
// Install Excel.IO as a Cake Tool
#tool nuget:?package=Excel.IO&version=0.8.0
Excelio
A simple way to read and write data to Excel.
Excelio is built to make getting data out of an Excel document as easy as possible. To do this Excelio uses the standard OpenXml library to handle the hard stuff then hides the complexity and provides a simple easy to use interface. As bonus using OpenXml directly makes Excelio pretty fast!
First of let’s start with a simple example. What if you want to open an Excel doc and pull a sheet into an array.
string[,] arr = ExcelIO.WorkBook.ToArray("Example.xlsx", "Sheet1");
Keep the document open and pull from more than one sheet.
using (var wb = new ExcelIO.WorkBook("Example.xlsx"))
{
string[,] sheet1Arr = wb.Sheets[0].ToArray();
string[,] sheet2Arr = wb.Sheets[1].ToArray();
}
Open a document and pull a specific cell.
using (var wb = new ExcelIO.WorkBook("Example.xlsx"))
{
string C4Value = wb.Sheets.First().GetCell("C4").Value;
}
Set a single cell to a value and save.
using (var wb = new ExcelIO.WorkBook("Example.xlsx"))
{
var C4Value = "New Value";
wb.Sheets.First().SetCell("C4", C4Value);
wb.Save();
}
Fill in a full sheet from an array.
var cells = new string[,]
{
{ "one" },
{ "two" },
{ "three" }
};
using (var wb = new ExcelIO.WorkBook("Example.xlsx"))
{
wb.Sheets.First().Set(cells);
wb.Save();
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
-
net6.0
- DocumentFormat.OpenXml (>= 2.18.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
0.8.0 | 239 | 9/20/2022 |