Hello All, I am planning to write a small Perl script to diff 2 excel sheets (workbooks) using the module - Spreadsheet::ParseExcel.
I am planning to implement following algorithm. What we can do is to pick up a worksheet at time (inside a loop) from each of the 2 workbooks and compare the cell values. 1. I would start with storing the cell values inside 2 hashes (1 hash for each worksheet). 2. So for first worksheet, its hash would have keys like A1, A2, A3 ... B1, B2, B3 ... C1, C2, C3 ... etc and values of these keys would be contents of the corresponding cells. 3. Similarly I would create another hash for corresponding worksheet of second workbook and it would have the same data structure as the first hash. 4. Then I would pick corresponding keys from each hash and compare the contents of the related cells using 'eq' operator. And again repeat the steps from 1 to 4 for the other corresponding worksheets of the 2 workbooks. So what I actually want to know is that - do we already have a module that will do the above steps or shall I go ahead with my algorithm. Cheers, Parag
