$p = "C:\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())
$content = $r.ReadToEnd()
$r.Close()
[xml]$x = $content

foreach ($s in $x.SelectNodes("//*[local-name()='sheet']")) {
$state = $s.GetAttribute("state")
if (!$state) {$state = "visible"}
Write-Host "ЛИСТ: $($s.GetAttribute('name')) | СОСТОЯНИЕ: $state" -ForegroundColor Green
}

$z.Dispose()
Write-Host "ГОТОВО"