SpreadSheetTasks 0.2.2

.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.2                

                    
                

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

                    
                

            
#r "nuget: SpreadSheetTasks, 0.2.2"
#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.2

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

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 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. 
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.

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