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

You will want to look through the MS Office / Excel Object Model - the Row object has the Hidden property I think.

An easy way to find such stuff without reading documentation is to Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks). The whole of Using Win32::OLE and Excel - Tips and Tricks is worth a read.

  • Comment on Re^3: Win32::OLE and Excel: Iterating when certain row numbers are missing
  • Download Code