more useful options | |
PerlMonks |
Re: Comparing two excel workbook and copy the values if the cell are matchby Laurent_R (Canon) |
on Sep 26, 2017 at 20:17 UTC ( [id://1200150]=note: print w/replies, xml ) | Need Help?? |
Hi naga7667,
You probably want to start by storing the content of the Speclis.xls into a hash, with the string (e.g. asd) as key and number (e.g. 25) as value. Once this is done, you read the Logsheet.xls, retrieve en value of the E column for each row, and lookup into the hash to find the value to be stored in column AU.
In Section
Seekers of Perl Wisdom
|
|