/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/PivotTableFilters/testPivotFilter.ps1
35 строк
777 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} $xlFile="$env:TEMP\testPivot.xlsx" Remove-Item $xlFile -ErrorAction Ignore $data =@" Region,Area,Product,Units,Cost North,A1,Apple,100,.5 South,A2,Pear,120,1.5 East,A3,Grape,140,2.5 West,A4,Banana,160,3.5 North,A1,Pear,120,1.5 North,A1,Grape,140,2.5 "@ | ConvertFrom-Csv $data | Export-Excel $xlFile -Show ` -AutoSize -AutoFilter ` -IncludePivotTable ` -PivotRows Product ` -PivotData @{"Units"="sum"} -PivotFilter Region, Area -Activate <# Creates a Pivot table that looks like Region All^ Area All^ Sum of Units Row Labels Total Apple 100 Pear 240 Grape 280 Banana 160 Grand Total 780 #>