http://qs321.pair.com?node_id=1193002


in reply to XLSX retriving if matches

An old-school way to do it is to:

  1. Initialize an array at the start of each row;
  2. Initialize a processing flag to false at the start of each row;
  3. Push each cell into that array as it is processed during the inner loop;
  4. Set the processing flag to true when you have your $patternmatch;
  5. At the bottom of the row loop, after processing all the cells in that row, if the flag is set, the array contains the complete row so use it accordingly.