Develop comparison program in python. Should take two excel files with different or same rows as input and perform comparison b/w worksheets. It should generate comparison report.
1. Compare program should perform comparison between two excel files and workbooks within them and generate report based on differences.
2. comparison at the row count level and % difference between file1 and file2 each tab/excel along with the specific names of the tab sheet.
3. Comparison at column/cell level and % difference between file1 and file2 for each tab/excel along with the specific names of the cell/column together with the tab/ worksheet.
4. Overall status of the comparison like pass or fail. If failed, then reason example Fail record count mismatch in Tab name or value mismatch in cell/ column in worksheet name.