Script to compare to excel files and print differences

Question

Is there any script handy to compare 2 excel sheets and print only their differences?

score 3 · Answer 1 · answered Mar 10 '17 at 23:12

3

You can use xlsx2csv to export the sheets from an Excel file as CSV files, and then simply diff them.

answered Mar 10 '17 at 23:12

DopeGhoti

score 1 · Answer 2 · answered Mar 11 '17 at 07:30

1

Convert XLS into csv files with comma delimiters then sort the csv files and then do gvim -d csv1 csv2

this will simply print the differences in the XLS files

answered Mar 11 '17 at 07:30

Bhanesh Bhadrecha

2 Answers2