Skip to content

Import-Excel can use an Excel Package

Compare
Choose a tag to compare
@dfinke dfinke released this 26 May 18:48
· 650 commits to master since this release

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.