ExcelCompare is a desktop application designed as a small tool for banking staff to process people's salaries through Excel sheets. The motivation behind this project is to provide a simple and efficient way for banking staff to check for discrepancies in case someone modifies the Excel sheets in any way.
The application allows users to compare two Excel sheets and display the differences between them. It provides a user-friendly interface for browsing and selecting the original and compare sheets, and it highlights the differences row-wise. The application is built using PySide6 for the graphical user interface and pandas for reading and comparing Excel data.
- Select and load the original Excel sheet.
- Select and load the compare Excel sheet.
- Compare the two sheets and identify differences.
- Display the differences in a read-only field.
- Python 3.x
- PySide6
- pandas
- Poetry (optional, for simplified dependency management)
- Clone the repository:
git clone https://github.com/your-username/excel-comparator.git- Change to the project directory:
cd excel-comparator- Install the required dependencies using pip:
pip install PySide6 pandasAlternatively, if you prefer to use Poetry for dependency management:
poetry installIf you don't have Poetry installed, you can follow the installation instructions from the official Poetry documentation: https://python-poetry.org/docs/#installation
- Run the application:
Copy code
python main.py-
The Excel Comparator window will appear.
-
Click the "Browse" button next to "Original Sheet" and select the Excel sheet you want to use as the original.
-
Click the "Browse" button next to "Compare Sheet" and select the Excel sheet you want to compare against the original.
-
Click the "Compare" button to start the comparison process.
-
The differences between the original and compare sheets will be displayed in the "Differences" field.
-
Click the "Credits" button to view the developer and sponsor information.
Contributions to ExcelComparator are welcome! If you find a bug or want to suggest an enhancement, please open an issue or submit a pull request.
This project is licensed under the MIT License.