NReco.PivotData.Extensions 1.3.7

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

Install-Package NReco.PivotData.Extensions -Version 1.3.7

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

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

paket add NReco.PivotData.Extensions --version 1.3.7

Release Notes

Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some limitations / trial notices).
Online demo: http://pivottable.nrecosite.com/
Usage examples: https://www.nrecosite.com/pivot_data_library_net.aspx

v.1.3.7 changes:
- fixed incorrect difference percentage calculation in DifferencePivotTable (now works like in Excel)
- now FixedPivotData uses pregrouped totals if they are present in PivotDataState (the same behavior as in PivotData class)
- now GroupedSourceReader supports all standard aggregator types (CountUnique, Variance etc)
- now it is possible to specify variance value mode (as 2nd parameter) for "Variance" aggregator in PivotDataFactory

v.1.3.6 changes:
- added RunningValuePivotTable wrapper: calculates running total (or running value for specified aggregator)
- added HeatmapPivotTable that highlights max values (HTML/Excel writers only)
- fixed issue with PivotTableHtmlWriter (invalid character exception)
- fixed issue with AggregatorFactoryConfiguration.Equals
- fixed issue with DifferencePivotTable (argument null exception)

Complete changes log: https://www.nrecosite.com/pivot_data_library_net.aspx#release_notes

Dependencies

• .NETFramework 4.0

  • CsvHelper (>= 2.15.0.2)
  • EPPlus (>= 4.0.4)
  • Newtonsoft.Json (>= 9.0.1)
  • NReco.PivotData (>= 1.3.4)

• .NETStandard 1.5

  • CsvHelper (>= 2.15.0.2)
  • NETStandard.Library (>= 1.6.0)
  • Newtonsoft.Json (>= 9.0.1)
  • NReco.PivotData (>= 1.3.4)
  • Shaman.EPPlus (>= 1.0.1.1)
  • System.Data.Common (>= 4.1.0)
  • System.Reflection (>= 4.1.0)
  • System.Reflection.Primitives (>= 4.0.1)
  • System.Security.Cryptography.Algorithms (>= 4.2.0)
  • System.Security.Cryptography.Cng (>= 4.2.0)
  • System.Threading (>= 4.0.11)
  • System.Threading.Tasks (>= 4.0.11)
  • System.Threading.Tasks.Parallel (>= 4.0.1)
  • System.Xml.ReaderWriter (>= 4.0.11)

Used By

Version History