Examples/Import-Excel/ImportMultipleSheetsAsHashtable.ps1
|
Import-Module $PSScriptRoot\..\..\ImportExcel.psd1 -Force $xlfile = "$PSScriptRoot\yearlySales.xlsx" $result = Import-Excel -Path $xlfile -WorksheetName * foreach ($sheet in $result.Values) { $sheet } |