Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: Comparing two Excel spread sheets

by simon.proctor (Vicar)
on Apr 21, 2006 at 09:01 UTC ( #544822=note: print w/ replies, xml ) Need Help??

in reply to Comparing two Excel spread sheets

Well if you only have two sheets, one in each. You could just save each out as csv's and do a diff. Any diffs and they aren't the same.

But that iimplies that you want to do a like for like comparison on data and data position.

Comment on Re: Comparing two Excel spread sheets
Replies are listed 'Best First'.
Re^2: Comparing two Excel spread sheets
by Win (Novice) on Apr 21, 2006 at 09:13 UTC
    That is exactly what I want to do. Would I use the diff command with MS DOS or something else? And can anyone guide me as to what the best directory to save these files to in Windows would be? Given that the excel spreadsheet that performs this task could be on anyone’s machine in our group (they all have Perl installed now - by the way). Some people use XP and others use Windows 2000.

    Update : I think that I can use the COMP command that MS DOS understands.

      I'm not really sure about COMP; diff is a standard unix tool, you will find it in the UnxUtils collection. However also take into account the remark I made here: it may be relevant...

      All in all using perl with the suitable module to read the csv files and compare them record by record (stopping at the first discordance) will be more robust and shouldn't be terribly expensive from the computational pov.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://544822]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2015-11-27 08:17 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (722 votes), past polls