在Powershell中忽略隐藏的Excel工作表(Ignore Hidden Excel worksheets in Powershell)

在Powershell中忽略隐藏的Excel工作表(Ignore Hidden Excel worksheets in Powershell)

在PowerShell中循环工作表时，如何忽略隐藏的工作表？

可以说我有这样的循环

$excel = New-Object -ComObject excel.application $excel.visible = $False $excel.displayalerts=$False $workbook = $excel.Workbooks.Open($ExcelPath) foreach ($ws in $workbook.Worksheets) { #do stuff }

How do you ignore hidden worksheets when looping through the worksheets in powershell?

Lets say I have a loop like this

$excel = New-Object -ComObject excel.application $excel.visible = $False $excel.displayalerts=$False $workbook = $excel.Workbooks.Open($ExcelPath) foreach ($ws in $workbook.Worksheets) { #do stuff }

最满意答案

if($ws.Visible -eq 0) { # Hidden } else { # Visible } if($ws.Visible -eq 0) { # Hidden } else { # Visible }