NReco.PivotData.Extensions 1.3.6

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.6

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

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

paket add NReco.PivotData.Extensions --version 1.3.6

Release Notes

Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some limitations / trial notices).

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)

v.1.3.5 changes:
- fixed bug in PivotTableDataTableWriter (trial notice not removed even with valid key)
- PivotTableDataTableWriter now derives from PivotTableWriterBase and supports totals row/column/grand total (configurable)

v.1.3.4 changes:
- added PivotTableHtmlWriter.SubtotalDimensions option (define which dimensions should have sub-totals)
- added PivotTableHtmlWriter.SubtotalKeySuffix option (localization of " Total" suffix added to sub-totals label)
- added new PivotTableHtmlWriter methods for advanced table cells formatting: OnWriteValueCell  and OnWriteKeyCell
- fixed issues with TopPivotTable wrapper (exception when top limit is applied both on rows and columns, avoid adding of empty "other" groups)

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