Sylvan.Data.Excel
0.1.11-b0001
Prefix Reserved
See the version list below for details.
dotnet add package Sylvan.Data.Excel --version 0.1.11-b0001
NuGet\Install-Package Sylvan.Data.Excel -Version 0.1.11-b0001
<PackageReference Include="Sylvan.Data.Excel" Version="0.1.11-b0001" />
paket add Sylvan.Data.Excel --version 0.1.11-b0001
#r "nuget: Sylvan.Data.Excel, 0.1.11-b0001"
// Install Sylvan.Data.Excel as a Cake Addin #addin nuget:?package=Sylvan.Data.Excel&version=0.1.11-b0001&prerelease // Install Sylvan.Data.Excel as a Cake Tool #tool nuget:?package=Sylvan.Data.Excel&version=0.1.11-b0001&prerelease
Sylvan.Data.Excel
A cross-platform .NET library for reading Excel data files in .xlsx, .xlsb and .xls formats.
Provides readonly, row by row, forward-only access to the data.
There is no support for creating or editing Excel files.
Provides a familiar API via DbDataReader
, which is ideal for accessing rectangular, tabular data sets.
The library is a purely managed implementation with no external dependencies.
This library is currently the fastest and lowest allocating library for reading Excel data files in the .NET ecosystem, for all supported formats.
Installing
This library is still relatively immature and you might encounter issues while using it. If you do encounter any bugs, please report an issue in the github repository. Be aware that I will be unlikely to investigate any issue unless an example file can be provided reproducing the issue.
Sylvan.Data.Excel Nuget Package
Install-Package Sylvan.Data.Excel
Basic Usage
using Sylvan.Data.Excel;
// ExcelDataReader derives from System.Data.DbDataReader
// The Create method can open .xls, .xlsx or .xlsb files.
using ExcelDataReader edr = ExcelDataReader.Create("data.xls");
do
{
var sheetName = edr.WorksheetName;
// enumerate rows in current sheet.
while(edr.Read())
{
// iterate cells in row.
for(int i = 0; i < edr.FieldCount; i++)
{
var value = edr.GetString(i);
}
// Can use other strongly-typed accessors
// bool flag = edr.GetBoolean(0);
// DateTime date = edr.GetDateTime(1);
// decimal amt = edr.GetDecimal(2);
}
// iterates sheets
} while(edr.NextResult());
Exporting Excel data to CSV(s): (using Sylvan.Data.Excel and Sylvan.Data.Csv)
using Sylvan.Data.Excel;
using Sylvan.Data.Csv;
using var edr = ExcelDataReader.Create("data.xls");
do
{
var sheetName = edr.WorksheetName;
using CsvDataWriter cdw = CsvDataWriter.Create("data-" + sheetName + ".csv")
cdw.Write(edr);
} while(edr.NextResult());
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 is compatible. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- System.Memory (>= 4.5.1)
-
.NETStandard 2.1
- No dependencies.
NuGet packages (3)
Showing the top 3 NuGet packages that depend on Sylvan.Data.Excel:
Package | Downloads |
---|---|
GreatUtilities.Infrastructure
Essencial tools to agile development. |
|
Purcell
一个超高性能的Excel强类型读写映射库。(支持.xls .xlsx .csv) |
|
Sylvan.AspNetCore.Mvc.Excel
Package Description |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
0.4.26-b0001 | 783 | 12/3/2024 |
0.4.25 | 28,583 | 8/15/2024 |
0.4.25-b0001 | 114 | 8/14/2024 |
0.4.24 | 16,368 | 6/21/2024 |
0.4.23 | 4,543 | 6/3/2024 |
0.4.22 | 8,852 | 5/13/2024 |
0.4.21 | 574 | 5/5/2024 |
0.4.20 | 1,086 | 4/25/2024 |
0.4.20-b0001 | 206 | 4/1/2024 |
0.4.19 | 32,299 | 11/29/2023 |
0.4.18 | 3,061 | 11/16/2023 |
0.4.17 | 8,553 | 9/26/2023 |
0.4.17-b0004 | 138 | 9/22/2023 |
0.4.17-b0003 | 134 | 9/15/2023 |
0.4.17-b0002 | 301 | 9/12/2023 |
0.4.17-b0001 | 141 | 9/11/2023 |
0.4.16 | 6,470 | 9/8/2023 |
0.4.15 | 385 | 9/5/2023 |
0.4.14 | 19,432 | 8/17/2023 |
0.4.13 | 4,117 | 7/19/2023 |
0.4.13-b0001 | 169 | 7/12/2023 |
0.4.12 | 13,165 | 5/18/2023 |
0.4.11 | 5,994 | 4/25/2023 |
0.4.10 | 3,904 | 3/28/2023 |
0.4.9 | 2,503 | 3/3/2023 |
0.4.8 | 23,685 | 2/23/2023 |
0.4.7 | 1,208 | 2/22/2023 |
0.4.6 | 932 | 2/16/2023 |
0.4.6-b0001 | 150 | 2/10/2023 |
0.4.5 | 2,935 | 1/28/2023 |
0.4.4 | 1,630 | 1/18/2023 |
0.4.3 | 30,982 | 12/7/2022 |
0.4.2 | 901 | 11/25/2022 |
0.4.1 | 625 | 11/17/2022 |
0.4.0 | 7,462 | 11/2/2022 |
0.3.4 | 460 | 11/2/2022 |
0.3.3 | 6,658 | 9/12/2022 |
0.3.2 | 854 | 9/2/2022 |
0.3.1 | 1,096 | 9/1/2022 |
0.3.0 | 1,178 | 8/12/2022 |
0.2.3 | 545 | 8/10/2022 |
0.2.2 | 494 | 8/9/2022 |
0.2.1 | 795 | 7/18/2022 |
0.2.0 | 961 | 6/24/2022 |
0.2.0-b0004 | 176 | 6/23/2022 |
0.2.0-b0003 | 182 | 6/22/2022 |
0.2.0-b0002 | 200 | 6/21/2022 |
0.2.0-b0001 | 205 | 6/18/2022 |
0.1.12 | 557 | 6/16/2022 |
0.1.11 | 537 | 6/15/2022 |
0.1.11-b0006 | 211 | 6/6/2022 |
0.1.11-b0005 | 2,091 | 5/10/2022 |
0.1.11-b0004 | 186 | 5/2/2022 |
0.1.11-b0003 | 214 | 3/8/2022 |
0.1.11-b0002 | 183 | 2/28/2022 |
0.1.11-b0001 | 163 | 2/23/2022 |
0.1.10 | 4,541 | 2/22/2022 |
0.1.9 | 535 | 2/21/2022 |
0.1.8 | 518 | 2/20/2022 |
0.1.7 | 636 | 1/22/2022 |
0.1.6 | 1,359 | 1/13/2022 |
0.1.4 | 1,674 | 11/28/2021 |
0.1.3 | 418 | 10/18/2021 |
0.1.2 | 490 | 10/8/2021 |
0.1.1 | 439 | 10/5/2021 |
0.1.0 | 527 | 10/4/2021 |