So, i thought to give Pandas a try and amazingly I completed comparing the two excel files and writing the results to a new excel file in not more than 10 line of codes. Recently at work, I encountered the same issue and retrieving my old xlrd script was not an option. I can still recall that we have written long lines of code to achieve that. In those days I have used xlrd module to read and write the comparison result of both the files in an excel file.
Comparing two excel spreadsheets and writing difference to a new excel was always a tedious task and Long Ago, I was doing the same thing and the objective there was to compare the row,column values for both the excel and write the comparison to a new excel files.
