NReco.PivotData.Extensions 1.3.8

PivotData Toolkit (extends NReco.PivotData 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.

Release Notes

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

v.1.3.8 changes:
- PercentagePivotTable: calculate percentage even for negative base (like in Excel)
- FixedPivotData: added ability to load sub-totals from state (use-case: result of SELECT .. WITH CUBE or MDX query)
- PivotTableFactory: ignore incorrect measure index in "SortByValue"
- CsvSource: correct handling of headers with control symbols (like new line)
- fixed issue with pivot table writers when CompositeAggregatorFactory is configured for one aggregator

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

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.2)
  • 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)

• .NETStandard 2.0

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

Version History