Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

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]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2018-06-21 03:44 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (117 votes). Check out past polls.