NReco.PivotData.Extensions
1.5.0
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.
See the version list below for details.
Install-Package NReco.PivotData.Extensions -Version 1.5.0
dotnet add package NReco.PivotData.Extensions --version 1.5.0
<PackageReference Include="NReco.PivotData.Extensions" Version="1.5.0" />
paket add NReco.PivotData.Extensions --version 1.5.0
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
Release notes: https://www.nrecosite.com/pivotdata/bi-toolkit-release-notes.aspx
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)
v.1.4.2 changes:
- fixed issue with FixedPivotData.Count (returns zero until first indexer access)
- CubeKeywordFilter: do not lowercase keywords
- CubeKeywordFilter: fixed issue with AND filter by measures
- CubeKeywordFilter: enable conditions (>, <, =) for dimensions if hint is provided
- CubeKeywordFilter: fixed issue with index-out-of-range for filters like "aaa, +"
- HeatmapPivotTable: 2 new options for HeatmapMode "RowTotal" and "ColumnTotal"
v.1.4.1 changes:
- PivotTableHtmlWriter: fixed incorrect groups rendering if more than 3 dimensions are selected for rows or columns.
- PivotTableDataTableWriter: infer column type if possible to avoid object-type columns.
- CubeKeywordFilter: added ability to filter by measure value with syntax like "sum>20".
- CubeKeywordFilter: correct filtering by empty keyword or when started/ended with space char
- CubeKeywordFilter: now it is possible to resolve dimensions/measures by hints with custom handlers.
- PivotDataFactory: new 'Quantile' and 'Mode' aggregators are registered by default.
- PivotDataFactory: new 'Quantile' and 'Mode' aggregators are registered by default.
- Fixed issue with HeatmapPivotTable in TRIAL mode (without a license key).
- Updated NReco.PivotData.Extensions dependencies:
netstandard2.0 build now uses official EPPlus v.4.5.1 nuget package)
netstandard1.5 build uses EPPlus.Core v.1.5.4 nuget package (as official EPPlus doesn't support netstandard1.5)
Dependencies
-
.NETFramework 4.0
- EPPlus (>= 4.0.4)
- Newtonsoft.Json (>= 9.0.1)
- NReco.PivotData (>= 1.3.7)
-
.NETStandard 1.5
- EPPlus.Core (>= 1.5.4)
- NETStandard.Library (>= 1.6.1)
- Newtonsoft.Json (>= 9.0.1)
- NReco.PivotData (>= 1.3.7)
- System.Data.Common (>= 4.3.0)
- System.Reflection (>= 4.3.0)
- System.Reflection.Primitives (>= 4.3.0)
- System.Security.Cryptography.Algorithms (>= 4.3.0)
- System.Security.Cryptography.Cng (>= 4.3.0)
- System.Threading (>= 4.3.0)
- System.Threading.Tasks (>= 4.3.0)
- System.Threading.Tasks.Parallel (>= 4.3.0)
- System.Xml.ReaderWriter (>= 4.3.0)
-
.NETStandard 2.0
- EPPlus (>= 4.5.1)
- Newtonsoft.Json (>= 10.0.1)
- NReco.PivotData (>= 1.3.7)
Used By
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version History
Version | Downloads | Last updated |
---|---|---|
1.5.3 | 3,430 | 5/27/2020 |
1.5.2 | 3,450 | 12/30/2019 |
1.5.1 | 564 | 12/11/2019 |
1.5.0 | 6,798 | 3/17/2019 |
1.4.2 | 1,277 | 8/23/2018 |
1.4.1 | 21,153 | 4/12/2018 |
1.4.0 | 933 | 1/9/2018 |
1.3.8 | 1,169 | 9/25/2017 |
1.3.7 | 5,702 | 7/26/2017 |
1.3.6 | 678 | 6/26/2017 |
1.3.5 | 833 | 3/15/2017 |
1.3.4 | 1,124 | 2/1/2017 |
1.3.3 | 3,705 | 12/2/2016 |
1.3.2 | 1,758 | 10/18/2016 |
1.3.1 | 799 | 9/16/2016 |