/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/OpenExcelPackage/EnableFeatures.ps1
28 строк
726 B
dfinke
Add Enable-ExcelAutoFilter and Enable-ExcelAutofit example
30 апр 2022, 05:11
30 апр 2022, 05:11
f478e8a
Код
Авторство
О чём код?
# How to use Enable-ExcelAutoFilter and Enable-ExcelAutofit try { Import-Module $PSScriptRoot\..\..\ImportExcel.psd1 } catch { throw ; return } $data = ConvertFrom-Csv @" RegionInfo,StateInfo,Units,Price West,Texas,927,923.71 North,Tennessee,466,770.67 East,Florida,520,458.68 East,Maine,828,661.24 West,Virginia,465,053.58 North,Missouri,436,235.67 South,Kansas,214,992.47 North,North Dakota,789,640.72 South,Delaware,712,508.55 "@ $xlfile = "$PSScriptRoot\enableFeatures.xlsx" Remove-Item $xlfile -ErrorAction SilentlyContinue $data | Export-Excel $xlfile $excel = Open-ExcelPackage $xlfile Enable-ExcelAutoFilter -Worksheet $excel.Sheet1 Enable-ExcelAutofit -Worksheet $excel.Sheet1 Close-ExcelPackage $excel -Show