in reply to Re^2: Win32::OLE and Excel: Iterating when certain row numbers are missing
in thread Win32::OLE and Excel: Iterating when certain row numbers are missing

I think you posted your reply as I was posting my second update. There is indeed a "hidden" property exposed, as demonstrated in my line $sht->Cells(2, 1)->EntireRow->{Hidden} = 1;. You can test this with something like if ($row->{Hidden}) {do stuff}.

Update: I've now updated my code to demonstrate testing the hidden property.

Regards,

John Davies

In Section Seekers of Perl Wisdom