NReco.PivotData.Extensions
1.3.3
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.
See the version list below for details.
Install-Package NReco.PivotData.Extensions -Version 1.3.3
dotnet add package NReco.PivotData.Extensions --version 1.3.3
<PackageReference Include="NReco.PivotData.Extensions" Version="1.3.3" />
paket add NReco.PivotData.Extensions --version 1.3.3
Release Notes
Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some limitations / trial notices).
v.1.3.3 changes:
- added JsonSource: use JSON data (file, REST API response) as input for PivotData.
- PivotTableHtmlWriter RepeatKeysInGroups/RepeatDuplicateKeysAcrossDimensions options now can be enabled for rows, columns or both.
- added RepeatKeysInGroups and RepeatDuplicateKeysAcrossDimensions properties to PivotTableExcelWriter (they have the same affect as in PivotTableHtmlWriter).
- added PivotTableHtmlWriter.AllowHtml option (allows usage of HTML tags in table labels or cell values; false by default)
- fixed PivotTableExcelWriter output when there are no dimensions for rows.
v.1.3.2 changes:
- added PaginatePivotTable wrapper: used for effective pivot table pagination on the server-side + related internal changed
- added pagination support to front-end component (jquery.nrecopivottable.js) and ToolkitPivotReportMvc example
- added PivotTableHtmlWriter.RepeatKeysInGroups option (prevents labels grouping; false by default)
- added PivotTableHtmlWriter.RepeatDuplicateKeysAcrossDimensions option (prevents the same label merging across dimensions)
- added more formatting options to PivotTableCsvWriter / PivotTableExcelWriter
- GroupedSourceReader significant refactoring; some changes are NOT backward compatible.
- fixed FixedPivotData issue (ArgumentOutOfRange exception when PivotDataState contains only several values)
- fixed PivotTableDataTableWriter issue (appears when pivot table contains several measures)
v.1.3.1 changes:
- published NReco.PivotData.Extensions nuget package; it needs a license key to remove trial limitations
- CubeKeywordFilter enhancements: starts-with / ends-with syntax ( *keyword, keyword* ), dimension hints syntax (year:2015)
- PivotTableExcelWriter is now available in netstandard build (for .NET Core apps)
- added more formatting options to ExcelWriter and CsvWriter (FormatKey/FormatValue)
- fixed PivotTableJsonWriter JSON serialization issue (null and DBNull values)
- fixed PivotTableDataTableWriter nullreference exception when MinAggregator or MaxAggregator is used
Dependencies
-
.NETFramework 4.0
- CsvHelper (>= 2.15.0.2)
- EPPlus (>= 4.0.4)
- Newtonsoft.Json (>= 9.0.1)
- NReco.PivotData (>= 1.3.3)
-
.NETStandard 1.5
- CsvHelper (>= 2.15.0.2)
- NETStandard.Library (>= 1.6.0)
- Newtonsoft.Json (>= 9.0.1)
- NReco.PivotData (>= 1.3.3)
- 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
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,282 | 5/27/2020 |
1.5.2 | 3,406 | 12/30/2019 |
1.5.1 | 564 | 12/11/2019 |
1.5.0 | 6,716 | 3/17/2019 |
1.4.2 | 1,272 | 8/23/2018 |
1.4.1 | 21,089 | 4/12/2018 |
1.4.0 | 928 | 1/9/2018 |
1.3.8 | 1,165 | 9/25/2017 |
1.3.7 | 5,694 | 7/26/2017 |
1.3.6 | 676 | 6/26/2017 |
1.3.5 | 833 | 3/15/2017 |
1.3.4 | 1,120 | 2/1/2017 |
1.3.3 | 3,701 | 12/2/2016 |
1.3.2 | 1,735 | 10/18/2016 |
1.3.1 | 795 | 9/16/2016 |