Find hidden sheet in excel and delete it

[maninternet]

Hi all, I have a problem to create script to read some information form the excel.

The excel file that I get has contained some hidden sheet and make my script take wrong information from the file.

So my idea is create scrip to delete all hidden sheet in excel before start reading the value inside.

I try to use _Excel_SheetList() to check all sheet but it can do only listing all sheet inside the file but it didn't gave me any info for hidden sheet. So I still cannot let the script know which one is hidden sheet.

Can anyone help me for some sample script to solve my issue?

[water]

Welcome to AutoIt and the forum!

There is no "hidden" property for a WorkSheet. Just a "Visible" property to not show this Sheet.
_Excel_SheetList returns a 2D array with two properties for each WorkSheet (please see the help file for details).
Loop through the array and check the Visible property. If True ignore the WorkSheet.

$For $i = 0 to UBound($aWorkSheets) - 1
    If $aWorkSheets[$i][1].Visible = False Then
        ; Do what you want to do with a WorkSheet you have to ignore like write to a log file
    Else
        ; Process the Worksheet
    EndIf
Next

 

[maninternet]

Thank you water, this is the thing it want. It can run correctly.

[water]