NReco.PivotData.Extensions 1.6.1

The ID prefix of this package has been reserved for one of the owners of this package by Prefix Reserved
.NET Standard 2.0 .NET Framework 4.5
dotnet add package NReco.PivotData.Extensions --version 1.6.1
NuGet\Install-Package NReco.PivotData.Extensions -Version 1.6.1
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="NReco.PivotData.Extensions" Version="1.6.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.PivotData.Extensions --version 1.6.1
#r "nuget: NReco.PivotData.Extensions, 1.6.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install NReco.PivotData.Extensions as a Cake Addin
#addin nuget:?package=NReco.PivotData.Extensions&version=1.6.1

// Install NReco.PivotData.Extensions as a Cake Tool
#tool nuget:?package=NReco.PivotData.Extensions&version=1.6.1

PivotData Toolkit (extends NReco.PivotData OLAP library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentages, differences, running total, heatmap, topN/pagination/groups expand-collapse), CSV/JSON/SQL input data loaders, web-based reports builder for end-users. More details:

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

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
1.6.1 880 7/28/2022
1.5.5 3,199 4/12/2022
1.5.4 7,977 5/29/2021
1.5.3 12,316 5/27/2020
1.5.2 61,420 12/30/2019
1.5.1 881 12/11/2019
1.5.0 12,102 3/17/2019
1.4.2 2,076 8/23/2018
1.4.1 42,565 4/12/2018
1.4.0 1,390 1/9/2018
1.3.8 1,652 9/25/2017
1.3.7 6,974 7/26/2017
1.3.6 1,208 6/26/2017
1.3.5 1,284 3/15/2017
1.3.4 1,637 2/1/2017
1.3.3 4,200 12/2/2016
1.3.2 16,187 10/18/2016
1.3.1 1,659 9/16/2016

Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some data size limitations and trial notices).
ASP.NET pivot table online demo:
Examples download:

v.1.6.1 changes:
- fixed incorrect assembly version in 1.6.0 that can cause project's build error
- PivotTableExcelWriter: now it is possible to override AutoFitColumns to implement custom cells width adjustment logic

v.1.6.0 changes:
- FixedPivotData: now it is a thread-safe
- Added netstandard2.1 build (all new async API methods are available only in this build)
- Added IPivotDataSource.ReadDataAsync method with a default implementation (fallbacks to sync ReadData)
- DbCommandSource, DerivedSource implement ReadDataAsync
- Added SourceReader.ReadAsync method
- Added GroupedSourceReader.ReadAsync and ReadStateAsync methods

v.1.5.5 changes:
- PivotTableExcelWriter: fixed issue with incorrect colspans for subtotals/collapsed rows
- PivotTableExcelWriter: added ApplyDimensionKeyStyles protected method (used to customize 'headers' cells)
- PaginatePivotTable: fixed an exception when CompositeAggregator has only one nested aggregator
- CubeKeywordFilter: added Filter overload that returns actually applied filter (reconstructed conditions, all with 'hints')
- CsvSource: added an ability to handle CSVs with duplicate headers (column's index is added to the name to make it unique)

v.1.5.4 changes:
- RunningValuePivotTable: fixed issue with slow computations in case of multiple measures
- PivotTableJsonWriter: now it is possible to include sub-totals (this is controlled by SubtotalRows/SubtotalColumns properties)
- PivotTableFactory: fixed issue with incorrect grouping in expand/collapse mode (the same group may duplicate many times when axis is ordered by values)

v.1.5.3 changes:
- FixedPivotData: more efficient GetEnumerator implementation
- PivotTableHtmlWriter: fixed issue with incorrect colspan for disabled totals row when grand-total is enabled
- PivotTableFactory: added protected CreatePivotTableInstance method
- CubeKeywordFilter: added ResolveDimensionKey property (used for matching formatted values)

v.1.5.2 changes:
- hotfix for DifferencePivotTable: when underlying PivotData is configured with CompositeAggregatorFactory incorrect aggregator type is returned (which causes 'invalid cast' exception)

v.1.5.1 changes:
- HTML/Excel/CSV/DataTable writers: added ability to render totals at the beginning of the group (TotalsRowPosition and TotalsColumnPosition properties)
- TopPivotTable: added 'last N items' mode
- DifferencePivotTable: now differences are calculated for sub-totals if possible

v.1.5.0 changes:
- Expand/collapse (new feature): implemented as CollapsePivotTable class (used in exports) + PivotTableHtmlWriter.CollapseConfiguration property (used for interactive expand/collapse).
- Added PivotTableConfiguration.SortGroupsBySubtotals option that determines how group labels are ordered if PreserveGroupOrder is enabled
- Fixed issue when row-headers are not rendered when no columns and column with totals is disabled
- PivotDataDataTableWriter: added ability to include sub-totals
- Fixed incorrect handling of FormulaAggregator (when this is only aggregator)

Change log for all versions: