Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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.

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]
[Corion]: I'm looking into Firefox Accounts (to self-host bookmark synchronization, among other things) and the one thing I like about their documentation is that they include test vectors for ...
[Corion]: ... their hashes. Even though their backends claim to be open, they don't really seem to be geared towards self-hosting them, so I'm pondering writing a (simplicistic) Perl backend for my needs

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2017-11-18 17:00 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (277 votes). Check out past polls.