NReco.PivotData.Extensions 1.5.3

PivotData Toolkit (extends NReco.PivotData OLAP library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentage, difference, running total, heatmap, topN/pagination), CSV/TSV/JSON/SQL data sources, extract-transform-load (ETL) handlers, keyword-based filter etc.

Install-Package NReco.PivotData.Extensions -Version 1.5.3

dotnet add package NReco.PivotData.Extensions --version 1.5.3

<PackageReference Include="NReco.PivotData.Extensions" Version="1.5.3" />

paket add NReco.PivotData.Extensions --version 1.5.3

#r "nuget: NReco.PivotData.Extensions, 1.5.3"

// Install NReco.PivotData.Extensions as a Cake Addin
#addin nuget:?package=NReco.PivotData.Extensions&version=1.5.3

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

Release Notes

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: http://pivottable.nrecosite.com/
Examples download: https://www.nrecosite.com/pivot_data_library_net.aspx

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: https://www.nrecosite.com/pivotdata/bi-toolkit-release-notes.aspx

Dependencies

• .NETFramework 4.5

  • EPPlus (>= 4.0.4)
  • Newtonsoft.Json (>= 9.0.1)
  • NReco.PivotData (>= 1.3.8)

• .NETStandard 2.0

  • EPPlus (>= 4.5.1)
  • Newtonsoft.Json (>= 10.0.1)
  • NReco.PivotData (>= 1.3.8)

Used By

Version History