Hi Parag! On Saturday 12 Dec 2009 07:05:02 Parag Kalra wrote: > 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. >
You might wish to look at: http://search.cpan.org/dist/Test-Differences/ and or some of its dependencies. Regards, Shlomi Fish -- ----------------------------------------------------------------- Shlomi Fish http://www.shlomifish.org/ Optimising Code for Speed - http://shlom.in/optimise Bzr is slower than Subversion in combination with Sourceforge. ( By: http://dazjorz.com/ ) -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
