Import-Excel can use an Excel Package
Instead of specifying a path provides an Excel Package object (from Open-ExcelPackage
), using this avoids re-reading the whole file when importing multiple parts of it. To allow multiple read operations Import-Excel
does NOT close the package, and you should use Close-ExcelPackage -noSave
to close it.