Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Comparing Two excel

by Tux (Monsignor)
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
Comment on Re: Comparing Two excel
Download Code

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (6)
As of 2016-05-24 10:53 GMT
Find Nodes?
    Voting Booth?