PivotForge.Core 0.4.0-preview.5

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher.
This is a prerelease version of PivotForge.Core.
There is a newer prerelease version of this package available.
See the version list below for details. 
dotnet add package PivotForge.Core --version 0.4.0-preview.5
                    


                    

                
NuGet\Install-Package PivotForge.Core -Version 0.4.0-preview.5
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="PivotForge.Core" Version="0.4.0-preview.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="PivotForge.Core" Version="0.4.0-preview.5" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="PivotForge.Core" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add PivotForge.Core --version 0.4.0-preview.5
                    


                    

                
#r "nuget: PivotForge.Core, 0.4.0-preview.5"
#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. 
#:package PivotForge.Core@0.4.0-preview.5
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=PivotForge.Core&version=0.4.0-preview.5&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=PivotForge.Core&version=0.4.0-preview.5&prerelease
                    


                            Install as a Cake Tool

PivotForge Core

PivotForge Core is a dependency-light pivot table engine for .NET 8 and newer applications.

Features

  • Group rows and columns from objects, dictionaries, DataTable, JSON, or CSV
  • Sum, count, average, minimum, and maximum aggregations
  • Filters and row sorting by labels, totals, or a selected column value
  • Percentages, differences, percent differences, and running totals
  • Source-record drill-down for detail cells, subtotals, and grand totals
  • Result pagination and cooperative cancellation
  • Dependency-free .xlsx export

Installation

dotnet add package PivotForge.Core --version 0.1.0-preview.1

Create a pivot

using PivotForge.Core;

var sales = new[]
{
    new { Region = "North", Year = 2025, Amount = 120m },
    new { Region = "North", Year = 2026, Amount = 180m },
    new { Region = "South", Year = 2026, Amount = 90m }
};

var request = new PivotRequest
{
    Rows = ["Region"],
    Columns = ["Year"],
    Values = [PivotValueDefinition.Sum("Amount")]
};

var result = new PivotEngine().Execute(sales, request);

Pass a CancellationToken to the Execute overload for cancellable calculations.

Drill down

var records = new PivotEngine().DrillDown(
    sales,
    request,
    rowPath: ["North"],
    columnPath: ["2026"]);

Use an empty path for an axis total or a prefix path for a subtotal.

Pagination

var page = PivotResultPaginator.CreatePage(result, offset: 0, pageSize: 100);

Excel export

using PivotForge.Core.Excel;

var document = new PivotExcelDocument
{
    Title = "Sales Pivot",
    Rows =
    [
        new PivotExcelRow
        {
            Cells =
            [
                new PivotExcelCell { Text = "Region", Role = PivotExcelCellRole.Header },
                new PivotExcelCell { Text = "Amount", Role = PivotExcelCellRole.Header }
            ]
        }
    ]
};

var xlsx = new PivotExcelExporter().Export(document);
File.WriteAllBytes("pivot.xlsx", xlsx);

PivotForge Core is licensed under the MIT License.

Product Compatible and additional computed target framework versions.
.NET 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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • net8.0

    • No dependencies.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on PivotForge.Core:

Package Downloads
PivotForge.AspNetCore

An interactive ASP.NET Core pivot table UI powered by PivotForge. Includes static web assets, endpoint registration, drill-down, Excel and CSV export, conditional formatting, large-data paging, request cancellation, and caching.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
0.13.0-preview.1 58 10/19/2026
0.12.0-preview.1 60 10/19/2026
0.11.0-preview.1 55 10/18/2026
0.10.0-preview.1 59 10/18/2026
0.9.0-preview.1 54 10/18/2026
0.8.0-preview.1 55 10/18/2026
0.7.0-preview.1 65 10/17/2026
0.6.0-preview.6 72 10/2/2026
0.6.0-preview.5 65 9/30/2026
0.6.0-preview.4 70 9/30/2026
0.6.0-preview.3 58 9/30/2026
0.6.0-preview.2 67 9/30/2026
0.6.0-preview.1 62 9/29/2026
0.5.0-preview.1 97 8/17/2026
0.4.0-preview.8 78 8/16/2026
0.4.0-preview.7 82 8/16/2026
0.4.0-preview.6 86 8/16/2026
0.4.0-preview.5 81 8/16/2026
0.4.0-preview.4 70 8/16/2026
0.4.0-preview.3 74 8/16/2026
Loading failed

Version-aligned preview release; the changes in this version apply to PivotForge.AspNetCore.