Reading Time: < 1 minute

Little trick a great colleague showed me to unhide a sheet in Excel :

In powershell

$objExcel = New-Object -ComObject Excel.Application
$objExcel.Visible = $true
$WorkBook = $objExcel.Workbooks.Open(“C:\Temp\hiddensheet.xls”)
$WorkBook.Sheets.Item(2).Visible = 1
Write-Output “Found : ” $WorkBook.Sheets.Item(2).name
$WorkBook.Sheets.Item(2).activate()

0