in reply to XLSX retriving if matches
An old-school way to do it is to:
- Initialize an array at the start of each row;
- Initialize a processing flag to false at the start of each row;
- Push each cell into that array as it is processed during the inner loop;
- Set the processing flag to true when you have your $patternmatch;
- 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.
<Reveal this spoiler or all in this thread>
In Section
Seekers of Perl Wisdom