Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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]
[marioroy]: Today, wanted to revisit running parallel Re: Crash with ForkManager on Windows. I tried running on Cygwin for comparison.
[marioroy]: Running parallel on Cygwin feels like running on Unix ;-)
[marioroy]: Fortunately, Strawberry Perl v5.26 runs well.
[karlgoethebier]: marioroy: He! Magic Mushrooms was a talk in the CB some days ago ;-)

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (7)
As of 2017-09-23 16:02 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (272 votes). Check out past polls.