[Novalug] OT: comparing spreadsheet data files, and displaying results

[James (Jim) Darlack]

Hi Friends,
   
  Im looking for a method of comparing and displaying two Microshaft Excel Spreadsheet files.  The content are daily job postings within a company.  There are many postings, and it is difficult to spot any new postings. Especially when the new postings are scattered within the spreadsheet
   
  I would use one spreadhseet as a baseline form one month ago, and compare the current postings, spending particular attention to the latest ones.  Hopefully, the tool would note a new row, then resync and ignore subsequent identical rows.
   
  Another comparison, would be comparison with the postings of the previous day.
   
  Since Excel exports data in various formats, I am thinking that their may be an Open Source tool on SourceForge or elsewhere containing a method of exporting the data files, then performing a comparison with .CSV or pipe delimited files.
   
  Any help or info is appreciated.
  Jim

       
---------------------------------
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://calypso.tux.org/pipermail/novalug/attachments/20070705/216a9f9f/attachment.html