PivotForge.Core 0.6.0-preview.6

.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. 
dotnet add package PivotForge.Core --version 0.6.0-preview.6
                    


                    

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


                            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.6.0-preview.6
                    


                    

                
#r "nuget: PivotForge.Core, 0.6.0-preview.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. 
#:package PivotForge.Core@0.6.0-preview.6
#: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.6.0-preview.6&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=PivotForge.Core&version=0.6.0-preview.6&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 is compatible.  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.

  • net10.0

    • No dependencies.

  • 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.6.0-preview.6 59 10/2/2026
0.6.0-preview.5 60 9/30/2026
0.6.0-preview.4 64 9/30/2026
0.6.0-preview.3 52 9/30/2026
0.6.0-preview.2 61 9/30/2026
0.6.0-preview.1 60 9/29/2026
0.5.0-preview.1 94 8/17/2026
0.4.0-preview.8 75 8/16/2026
0.4.0-preview.7 79 8/16/2026
0.4.0-preview.6 82 8/16/2026
0.4.0-preview.5 76 8/16/2026
0.4.0-preview.4 67 8/16/2026
0.4.0-preview.3 71 8/16/2026
0.4.0-preview.2 79 8/16/2026
0.4.0-preview.1 69 8/16/2026
0.3.0-preview.2 75 8/16/2026
0.3.0-preview.1 86 8/16/2026
0.2.0-preview.1 76 8/15/2026
0.1.0-preview.2 82 8/14/2026
0.1.0-preview.1 85 8/14/2026

See https://github.com/alican645/PivotForge/blob/main/CHANGELOG.md for the changes in this and every earlier version.