/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/InvokeExcelQuery/Examples.ps1
14 строк
483 B
dfinke
Minor tweak. Display query executed
13 ноя 2021, 01:25
13 ноя 2021, 01:25
1ee9493
Код
Авторство
О чём код?
try { Import-Module $PSScriptRoot\..\..\ImportExcel.psd1 } catch { throw ; return } $queries = 'select * from [sheet1$A:A]', 'select * from [sheet1$]', 'select * from [sheet1$A2:E11]', 'select F2,F5 from [sheet1$A2:E11]', 'select * from [sheet1$A2:E11] where F2 = "Grocery"', 'select F2 as [Category], F5 as [Discount], F5*2 as [DiscountPlus] from [sheet1$A2:E11]' foreach ($query in $queries) { "query: $($query)" Invoke-ExcelQuery .\testOleDb.xlsx $query | Format-Table }