PivotForge
Dependency-light pivot table engine and ASP.NET Core UI for .NET
An open-source pivot table engine and Razor Class Library designed as a free alternative to paid components such as DevExpress and Syncfusion. Published on NuGet as PivotForge.Core and PivotForge.AspNetCore.
- Period
- Aug 2026 – Present
- Role
- Sole developer · Published on NuGet
- Status
- Open source
- Platforms
- NuGet
Overview
The calculation engine has zero external dependencies: expression-tree compiled property accessors, single-pass aggregation (Sum, Count, Average, Min, Max), 7 show-as modes, culture-aware collation, drill-down, pagination and cancellation. Excel export comes from a raw OpenXML writer built only on ZipArchive and XmlWriter.
The same pivot can be declared three ways: Razor Tag Helpers, fluent C# HTML helpers and a vanilla JavaScript API, so fully interactive pivot grids need no hand-written JS.
Highlights
- Drag-and-drop field designer with keyboard and touch support
- Filter picker, drill-down detail modal, saved views, conditional formatting
- Virtual scrolling with an LRU cache and full ARIA grid accessibility
- 6 Minimal API endpoints, atomic result caching with SemaphoreSlim-based thundering-herd protection, session paging for large datasets
- xUnit, Node.js DOM-stub and Playwright E2E tests on GitHub Actions CI
Screens
Screenshots coming soon