RemoveWorksheet.ps1
|
Function Remove-WorkSheet { Param ( $Path, $WorksheetName ) $Path = (Resolve-Path $Path).ProviderPath $Excel = New-Object -TypeName OfficeOpenXml.ExcelPackage $Path $workSheet = $Excel.Workbook.Worksheets[$WorkSheetName] if($workSheet) { if($Excel.Workbook.Worksheets.Count -gt 1) { $Excel.Workbook.Worksheets.Delete($workSheet) } else { throw "Cannot delete $WorksheetName. A workbook must contain at least one visible worksheet" } } else { throw "$WorksheetName not found" } $Excel.Save() $Excel.Dispose() } Import-Module .\ImportExcel.psd1 -Force $names = Get-ExcelSheetInfo C:\Temp\testDelete.xlsx $names | Foreach-Object { Remove-WorkSheet C:\Temp\testDelete.xlsx $_.Name} ##Remove-WorkSheet C:\Temp\testDelete.xlsx sheet6 |