SpreadSheetTasks 0.2.9

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package SpreadSheetTasks --version 0.2.9                

                    
                

            
NuGet\Install-Package SpreadSheetTasks -Version 0.2.9
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. 
<PackageReference Include="SpreadSheetTasks" Version="0.2.9" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SpreadSheetTasks --version 0.2.9                

                    
                

            
#r "nuget: SpreadSheetTasks, 0.2.9"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install SpreadSheetTasks as a Cake Addin
#addin nuget:?package=SpreadSheetTasks&version=0.2.9

// Install SpreadSheetTasks as a Cake Tool
#tool nuget:?package=SpreadSheetTasks&version=0.2.9

SpreadSheetTasks

The .NET library for fast reading and writing Excel files (.xlsx, .xlsb). Some methods/ideas based on great libraries :

Installation

https://www.nuget.org/packages/SpreadSheetTasks/

Install-Package SpreadSheetTasks

dotnet add package SpreadSheetTasks

Usage

Read

using (XlsxOrXlsbReadOrEdit excelFile = new XlsxOrXlsbReadOrEdit())
{
   excelFile.Open("file.xlsx");
   excelFile.ActualSheetName = "sheet1";
   object[] row = null;
   while (excelFile.Read())
   {
       if (row == null)
       {
           row = new object[excelFile.FieldCount];
       }
       excelFile.GetValues(row);
   }
}

Write

using (XlsbWriter xlsx = new XlsbWriter("file.xlsb"))
{
  xlsx.AddSheet("sheetName");
  xlsx.WriteSheet(dataReader);
}

Benchamarks and more

XLSB Read

Method FileName Mean Error StdDev Gen0 Gen1 Gen2 Allocated
'SpreadSheetTasks - XLSB Read - v1' 200kFile.xlsb 117.29 ms 1.907 ms 1.784 ms 3400.0000 2800.0000 1400.0000 68.49 MB
'SpreadSheetTasks - XLSB Read - v2' 200kFile.xlsb 138.62 ms 2.752 ms 2.826 ms 3000.0000 2000.0000 1000.0000 49.03 MB
'Sylvan.Data.Excel - XLSB Read' 200kFile.xlsb 147.70 ms 1.693 ms 1.500 ms 3000.0000 2500.0000 1500.0000 50.82 MB
'SpreadSheetTasks - XLSB Read - v1' 65K_R(...).xlsb [21] 60.25 ms 0.504 ms 0.447 ms 1555.5556 777.7778 777.7778 28.83 MB
'SpreadSheetTasks - XLSB Read - v2' 65K_R(...).xlsb [21] 75.96 ms 0.346 ms 0.323 ms 666.6667 - - 13.66 MB
'Sylvan.Data.Excel - XLSB Read' 65K_R(...).xlsb [21] 90.80 ms 0.641 ms 0.535 ms 1000.0000 - - 23.16 MB

XLSB Write

Method Rows Mean Error StdDev Allocated
'SpreadSheetTasks - XLSB Write' 200000 466.0 ms 1.27 ms 1.06 ms 30.57 MB
XlsbSylvanWrite 200000 242.3 ms 2.19 ms 1.83 ms 36.75 MB

https://github.com/KrzysztofDusko/SpreadSheetTasks

Product 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 is compatible.  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 is compatible.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • net6.0

    • No dependencies.

  • net7.0

    • No dependencies.

  • net8.0

    • No dependencies.

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.3.2 108 10/23/2024
0.3.1 144 8/25/2024
0.3.0 191 5/12/2024
0.2.17 222 2/16/2024
0.2.16 114 2/15/2024
0.2.14 206 1/13/2024
0.2.13 151 1/6/2024
0.2.12 216 11/25/2023
0.2.11 167 11/4/2023
0.2.10 154 11/4/2023
0.2.9 131 11/4/2023
0.2.8 141 9/26/2023
0.2.7 147 9/19/2023
0.2.6 146 9/18/2023
0.2.5 145 9/16/2023
0.2.4 404 3/5/2023
0.2.3 625 12/1/2022
0.2.2 452 10/22/2022
0.2.1 453 8/9/2022
0.2.0 415 8/7/2022
0.1.2 543 3/21/2022
0.1.1 354 12/3/2021
0.1.0 334 11/9/2021
0.0.4 430 10/23/2021
0.0.3 435 10/17/2021
0.0.2 350 9/19/2021
0.0.1 330 9/18/2021

Performance improvements, Csv writer preview