NReco.PivotData.Extensions
1.6.1
dotnet add package NReco.PivotData.Extensions --version 1.6.1
NuGet\Install-Package NReco.PivotData.Extensions -Version 1.6.1
<PackageReference Include="NReco.PivotData.Extensions" Version="1.6.1" />
paket add NReco.PivotData.Extensions --version 1.6.1
#r "nuget: NReco.PivotData.Extensions, 1.6.1"
// Install NReco.PivotData.Extensions as a Cake Addin
#addin nuget:?package=NReco.PivotData.Extensions&version=1.6.1
// Install NReco.PivotData.Extensions as a Cake Tool
#tool nuget:?package=NReco.PivotData.Extensions&version=1.6.1
PivotData Toolkit (extends NReco.PivotData OLAP library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentages, differences, running total, heatmap, topN/pagination/groups expand-collapse), CSV/JSON/SQL input data loaders, web-based reports builder for end-users. More details: https://www.nrecosite.com/pivot_data_library_net.aspx
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 net481 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
.NETFramework 4.5
- EPPlus (>= 4.0.4)
- Newtonsoft.Json (>= 9.0.1)
- NReco.PivotData (>= 1.4.0)
-
.NETStandard 2.0
- EPPlus (>= 4.5.1)
- Newtonsoft.Json (>= 10.0.1)
- NReco.PivotData (>= 1.4.0)
-
.NETStandard 2.1
- EPPlus (>= 4.5.1)
- Newtonsoft.Json (>= 10.0.1)
- NReco.PivotData (>= 1.4.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.6.1 | 909 | 7/28/2022 |
1.5.5 | 3,267 | 4/12/2022 |
1.5.4 | 8,044 | 5/29/2021 |
1.5.3 | 12,324 | 5/27/2020 |
1.5.2 | 61,847 | 12/30/2019 |
1.5.1 | 882 | 12/11/2019 |
1.5.0 | 12,129 | 3/17/2019 |
1.4.2 | 2,078 | 8/23/2018 |
1.4.1 | 42,698 | 4/12/2018 |
1.4.0 | 1,391 | 1/9/2018 |
1.3.8 | 1,652 | 9/25/2017 |
1.3.7 | 6,977 | 7/26/2017 |
1.3.6 | 1,208 | 6/26/2017 |
1.3.5 | 1,286 | 3/15/2017 |
1.3.4 | 1,641 | 2/1/2017 |
1.3.3 | 4,203 | 12/2/2016 |
1.3.2 | 16,323 | 10/18/2016 |
1.3.1 | 1,662 | 9/16/2016 |
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.6.1 changes:
- fixed incorrect assembly version in 1.6.0 that can cause project's build error
- PivotTableExcelWriter: now it is possible to override AutoFitColumns to implement custom cells width adjustment logic
v.1.6.0 changes:
- FixedPivotData: now it is a thread-safe
- Added netstandard2.1 build (all new async API methods are available only in this build)
- Added IPivotDataSource.ReadDataAsync method with a default implementation (fallbacks to sync ReadData)
- DbCommandSource, DerivedSource implement ReadDataAsync
- Added SourceReader.ReadAsync method
- Added GroupedSourceReader.ReadAsync and ReadStateAsync methods
v.1.5.5 changes:
- PivotTableExcelWriter: fixed issue with incorrect colspans for subtotals/collapsed rows
- PivotTableExcelWriter: added ApplyDimensionKeyStyles protected method (used to customize 'headers' cells)
- PaginatePivotTable: fixed an exception when CompositeAggregator has only one nested aggregator
- CubeKeywordFilter: added Filter overload that returns actually applied filter (reconstructed conditions, all with 'hints')
- CsvSource: added an ability to handle CSVs with duplicate headers (column's index is added to the name to make it unique)
v.1.5.4 changes:
- RunningValuePivotTable: fixed issue with slow computations in case of multiple measures
- PivotTableJsonWriter: now it is possible to include sub-totals (this is controlled by SubtotalRows/SubtotalColumns properties)
- PivotTableFactory: fixed issue with incorrect grouping in expand/collapse mode (the same group may duplicate many times when axis is ordered by values)
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