$p = "C:\Users\Users\Acer\Desktop\ttt.xlsx"
Add-Type -AssemblyName System.IO.Compression.FileSystem
$z = [IO.Compression.ZipFile]::OpenRead($p)
$e = $z.GetEntry("xl/workbook.xml")
$r = New-Object IO.StreamReader($e.Open())
[xml]$x = $r.ReadToEnd()
$r.Close()
foreach ($s in $x.SelectNodes("//*[local-name()='sheet']")) {
Write-Host "ЛИСТ: $($s.GetAttribute('name')) | СОСТОЯНИЕ: $(if($s.GetAttribute('state')){$s.GetAttribute('state')}else{'visible'})" -ForegroundColor Green
}
$z.Dispose()
Write-Host "ГОТОВО"