Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (13)
As of 2014-09-17 14:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (85 votes), past polls