NReco.PivotData.Extensions
1.3.5
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.5
dotnet add package NReco.PivotData.Extensions --version 1.3.5
<PackageReference Include="NReco.PivotData.Extensions" Version="1.3.5" />
paket add NReco.PivotData.Extensions --version 1.3.5
Release Notes
NOTE: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some limitations / trial notices).
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)
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)
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
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,532 | 5/27/2020 |
1.5.2 | 3,462 | 12/30/2019 |
1.5.1 | 568 | 12/11/2019 |
1.5.0 | 6,854 | 3/17/2019 |
1.4.2 | 1,277 | 8/23/2018 |
1.4.1 | 21,258 | 4/12/2018 |
1.4.0 | 934 | 1/9/2018 |
1.3.8 | 1,170 | 9/25/2017 |
1.3.7 | 5,712 | 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,777 | 10/18/2016 |
1.3.1 | 799 | 9/16/2016 |