Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: Comparing Two excel

by Tux (Abbot)
on Apr 07, 2014 at 14:17 UTC ( #1081403=note: print w/replies, xml ) Need Help??

in reply to Comparing Two excel

What Corion said, plus probably using export to CSV (or use the xls2csv utility that comes with Spreadsheet::Read) of both Excel files and then use the csvdiff utility that comes with Text::CSV_XS.

$ xlscat -c old.xls "Student ID",Name,Test,Grade 1,"Tom Hanks",Math,F 2,"Angelina Jolie",Biology,B 3,"David Gilmour",Music,A $ xlscat -c old.xls >old.csv $ xlscat -c new.xls "Student ID",Name,Test,Grade 1,"Tom Hanks",Math,B 2,"Angelina Jolie",Biology,B 3,"David Gilmour",Music,A 4,Bono,Singing,"F- (EPIC FAIL)" $ xlscat -c new.xls >new.csv $ csvdiff old.csv new.csv # csvdiff < old.csv > new.csv < 1,"Tom Hanks",Math,"F" > 1,"Tom Hanks",Math,"B" + 4,Bono,Singing,"F- (EPIC FAIL)"

When using csvdiff in a TTY, it'll try to use colors to make changes more obvious.

Enjoy, Have FUN! H.Merijn

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1081403]
[choroba]: Isn't Using PerlPod Creatively rather a meditation?
[choroba]: I don't see a question
[1nickt]: ugh, I stuck my head in the bass bin for 30 seconds on a dare at Ted Nugent at Hammersmith Odeon. Yes, I am 40% deaf now.
[johngg]: My daughter is incredibly jealous of my wife who got to see The Clash at Brixton many years ago. They went to see The Vaccines there recently.
[1nickt]: But the bands are even louder! I saw Spearhead (Michael Franti) at an outdoor show and had to walk a mile away to not feel pain in my chest! Babies were crying ... I asked the sound engineer why it was necessary to have the bass so loud and he laughed...
[Discipulus]: but the best i attended live was Mano Negra Patchanka at Forte Prenestino .. in 1990
[Corion]: Hmmm - Mano Negra or at least Manu Chao seem to put on a good live show. At least the one live CD I have from Manu Chao sounds good ;)
Discipulus feels the same jealousity of the johngg's daughter
[1nickt]: choroba I agree
[choroba]: Playing in a punk rock band for 20 years... my hearing is quite bad

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (13)
As of 2017-03-24 12:17 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (301 votes). Check out past polls.