SpreadSheetTasks 0.2.6

There is a newer version of this package available.
See the version list below for details.
dotnet add package SpreadSheetTasks --version 0.2.6
NuGet\Install-Package SpreadSheetTasks -Version 0.2.6
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.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SpreadSheetTasks --version 0.2.6
#r "nuget: SpreadSheetTasks, 0.2.6"
#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.6

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

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

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.2.17 152 2/16/2024
0.2.16 83 2/15/2024
0.2.14 138 1/13/2024
0.2.13 116 1/6/2024
0.2.12 183 11/25/2023
0.2.11 132 11/4/2023
0.2.10 117 11/4/2023
0.2.9 102 11/4/2023
0.2.8 110 9/26/2023
0.2.7 113 9/19/2023
0.2.6 107 9/18/2023
0.2.5 110 9/16/2023
0.2.4 374 3/5/2023
0.2.3 372 12/1/2022
0.2.2 412 10/22/2022
0.2.1 425 8/9/2022
0.2.0 379 8/7/2022
0.1.2 502 3/21/2022
0.1.1 332 12/3/2021
0.1.0 302 11/9/2021
0.0.4 395 10/23/2021
0.0.3 412 10/17/2021
0.0.2 319 9/19/2021
0.0.1 305 9/18/2021

Performance improvements, Csv writer preview