PowerShellUniversal.Component.Pivot.psd1
|
# # Module manifest for module 'PowerShellUniversal.Component.Pivot' # # Generated by: eizedev # # Generated on: 11/14/2026 # @{ # Script module or binary module file associated with this manifest. RootModule = 'PowerShellUniversal.Component.Pivot.psm1' # Version number of this module. ModuleVersion = '0.5.0' # Supported PSEditions # CompatiblePSEditions = @() # ID used to uniquely identify this module GUID = 'e59f7ff0-a6dc-4402-9729-98af8be5c83b' # Author of this module Author = 'eizedev' # Company or vendor of this module CompanyName = 'eizedev' # Copyright statement for this module Copyright = '(c) 2026 eizedev. MIT License.' # Description of the functionality provided by this module Description = 'Pivot report builder for PowerShell Universal apps: readers drag fields into rows, columns, values and filters and get a table or a chart, with date grouping, drill-down to the source rows, templates, undo, Excel, CSV, PNG, SVG and HTML export and the reader''s own CSV, JSON and Excel files read in the browser; light and dark theme, English and German, fed straight from SQL DataTables, REST results and PowerShell objects.' # Minimum version of the PowerShell engine required by this module PowerShellVersion = '7.4' # Name of the PowerShell host required by this module # PowerShellHostName = '' # Minimum version of the PowerShell host required by this module # PowerShellHostVersion = '' # Minimum version of Microsoft .NET Framework required by this module. This prerequisite is valid for the PowerShell Desktop edition only. # DotNetFrameworkVersion = '' # Minimum version of the common language runtime (CLR) required by this module. This prerequisite is valid for the PowerShell Desktop edition only. # ClrVersion = '' # Processor architecture (None, X86, Amd64) required by this module # ProcessorArchitecture = '' # Modules that must be imported into the global environment prior to importing this module # RequiredModules = @() # Assemblies that must be loaded prior to importing this module # RequiredAssemblies = @() # Script files (.ps1) that are run in the caller's environment prior to importing this module. # ScriptsToProcess = @() # Type files (.ps1xml) to be loaded when importing this module # TypesToProcess = @() # Format files (.ps1xml) to be loaded when importing this module # FormatsToProcess = @() # Modules to import as nested modules of the module specified in RootModule/ModuleToProcess # NestedModules = @() # Functions to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no functions to export. FunctionsToExport = 'New-UDPivotReport', 'New-UDPivotReportPlaceholder', 'ConvertFrom-UDPivotView', 'ConvertFrom-UDPivotViewFile', 'ConvertTo-UDPivotViewFile', 'New-UDPivotFileTemplateStore', 'New-UDPivotTemplateStore', 'Invoke-UDPivotTemplateRequest', 'Get-UDPivotSqlColumnDescription' # Cmdlets to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no cmdlets to export. CmdletsToExport = @() # Variables to export from this module # VariablesToExport = @() # Aliases to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no aliases to export. AliasesToExport = @() # DSC resources to export from this module # DscResourcesToExport = @() # List of all modules packaged with this module # ModuleList = @() # List of all files packaged with this module # FileList = @() # Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell. PrivateData = @{ PSData = @{ # Tags applied to this module. These help with module discovery in online galleries. Tags = 'PowerShellUniversal','UniversalDashboard','PSU','Pivot','PivotTable','Report','Dashboard','Excel','Visualization' # A URL to the license for this module. LicenseUri = 'https://github.com/eizedev/powershell-universal-components/blob/main/LICENSE' # A URL to the main website for this project. ProjectUri = 'https://github.com/eizedev/powershell-universal-components' # A URL to an icon representing this module. # IconUri = '' # ReleaseNotes of this module ReleaseNotes = '### Security - pivotkit-xlsx 0.3.1: a crafted Excel workbook could pass the size checks before parsing and fill the reader''s browser memory (denial of service in the reader''s own tab; [GHSA-c6vh-q36c-92r3](https://github.com/eizedev/pivotkit/security/advisories/GHSA-c6vh-q36c-92r3), pivotkit-xlsx 0.3.0 and earlier, so release 0.4.0 of this module with `-AllowImport`; update from 0.4.0). Workbooks with namespace-prefixed elements are checked like the others. Also, a workbook''s different texts and cell formats count against `importCells` while they are unpacked. ### Added - `-ImportLimit`: pivotkit''s limits for a file loaded with `-AllowImport` per report, e.g. `@{ fileBytes = 250MB; rows = 2000000 }` (`fileBytes`, `rows`, `columns`, `importCells`, `textLength`, `archiveEntries`, `unpackedBytes`; keys left out keep pivotkit''s defaults). They go to pivotkit-react''s `importLimits`, so the app''s `-Data` keeps pivotkit''s own limits. An unknown key or a value that is not a whole number of at least 1 is an error that names it ([#103](https://github.com/eizedev/powershell-universal-components/issues/103), [#106](https://github.com/eizedev/powershell-universal-components/issues/106)). ### Changed - pivotkit 0.6.1 ([pivotkit-react release](https://github.com/eizedev/pivotkit/releases/tag/pivotkit-react%400.6.1), [upgrading from 0.4](https://pivotkit.eize.dev/getting-started/upgrading/)): pivotkit-core and pivotkit-react 0.6.1, pivotkit-xlsx 0.3.1 and pivotkit-report 0.2.1, all pinned and in the one bundle (1.58 MB, 494 KB gzip). Export''s table as CSV is called **Table as CSV (.csv)**; pivotkit''s Source data export stays off (`-ExportData` follows, [#113](https://github.com/eizedev/powershell-universal-components/issues/113)). A view saved in the browser for a sheet of a loaded workbook opens on that sheet again. Dates before 1 AD carry their era ("Q1 2 BC"). Export has an HTML report, the chart as SVG and Print or save as PDF; Excel, the HTML report and print are light also from a dark app. Column subtotals are off unless a view turns them on (`totals = @{ colSubtotals = $true }`); views the report saves name all four totals. The chart''s text is 14 px, the font weights are four (`--psu-pivot-weight-*`). `-Tips` knows the tip `colSubtotals`. The filter menus write view version 2 (below). - A colour scale without colours of its own runs from light to strong blue, the heatmap''s colours, on screen and in the Excel export, not from red over yellow to green: it says "more", not "good" or "bad". `--psu-pivot-scale-low` and `--psu-pivot-scale-high` fall back to `--psu-pivot-heat-low` and `--psu-pivot-heat-high`; `--psu-pivot-scale-mid` adds a middle colour. The Themes page shows how to get red, yellow and green back ([#107](https://github.com/eizedev/powershell-universal-components/issues/107)). - Themes: the corporate stylesheet sets each mode for the page and for the theme the report shows (`:root, .ud-pivot-report [data-pk-theme="light"]` and `:root[data-theme="dark"], .ud-pivot-report [data-pk-theme="dark"]`), so the Excel export and the HTML report of a dark app take the light values and a report pinned with `-Theme` takes those of its own theme. A stylesheet with `:root[data-theme="dark"]` alone still themes the screen, but its dark values reach those files. - New theme properties: `--psu-pivot-input-border` and `--psu-pivot-rule` (the edge of a text field and the line between a menu''s groups, PSU''s neutral greys instead of pivotkit''s blue-grey) and `--psu-pivot-weight-normal`, `-medium`, `-strong` and `-bold`. The admin panel of `-AdminRole` takes the report''s corners, weights and text size (at least 14 px; its code was 13 px). - pivotkit''s view version 2 ([pivotkit#165](https://github.com/eizedev/pivotkit/issues/165)): every filter is `{ field, type, ..., not, blanks }` with the types `in`, `blank`, `text`, `compare`, `relative`, `top` and `value`. Views of version 1 (`include`, `exclude`, `label`, the operators `!=`, `notBetween`, `notEquals`, `notContains`) in `-View`, `-SavedView`, `-Templates`, view files, template stores and links still load with the same result: the report migrates them. The report writes version 2, so `-OnViewChange`, `Get-UDElement` and saved views carry it. - View files: `ConvertFrom-UDPivotViewFile`, `-TemplatePath` and the template stores read format versions 1 and 2 and views of version 1 and 2; a newer one is still refused. `ConvertTo-UDPivotViewFile` and the stores write format version 2 with `https://pivotkit.eize.dev/schema/view-file-2.json` for a view of version 2, and format version 1 with `view-file-1.json` for a view of version 1 or without a version, so stored views of version 1 stay readable by older releases. - The shipped view "Open work per team" and the showcase''s "Lead time per customer" are views of version 2. Docs: the Views page has a section on filters (types, `not`, `blanks`, version 1).' # Prerelease string of this module # Prerelease = '' # Flag to indicate whether the module requires explicit user acceptance for install/update/save # RequireLicenseAcceptance = $false # External dependent modules of this module # ExternalModuleDependencies = @() } # End of PSData hashtable } # End of PrivateData hashtable # HelpInfo URI of this module # HelpInfoURI = '' # Default prefix for commands exported from this module. Override the default prefix using Import-Module -Prefix. # DefaultCommandPrefix = '' } |