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.

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

Version History