|
|
|
| Welcome to the Monastery | |
| PerlMonks |
Re^3: Win32::OLE and Excel: Iterating when certain row numbers are missingby davies (Prior) |
| on Jun 21, 2021 at 15:01 UTC ( [id://11134110]=note: print w/replies, xml ) | Need Help?? |
|
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
|
|
||||||||||||||||||||||