/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/PivotTable/PivotTableWithName.ps1
25 строк
752 B
jhoneill
remove LoadPSD calls & 72 empty catch blocks from examples
18 ноя 2019, 01:45
18 ноя 2019, 01:45
66bf3ad
Код
Авторство
О чём код?
try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return} $ExcelParams = @{ Path = "$env:TEMP\test1.xlsx" IncludePivotTable = $true PivotRows = 'Company' PivotTableName = 'MyTable' PivotData = @{'Handles' = 'sum'} Show = $true Activate = $true } Remove-Item $ExcelParams.Path -ErrorAction Ignore Get-Process | Select-Object Company, Handles | Export-Excel @ExcelParams <# Builds a pivot table that looks like this: Sum of Handles Row Labels Total Adobe Systems Incorporated 3100 (blank) 214374 Apple Inc. 215 etc etc Grand Total 365625 #>