This project provides a user-friendly interface for comparing two Excel files column-wise.
- Compare Excel files based on column values.
- Supports .xlsx and .xls formats.
- Detailed result in a downloadable text file.
-
Upload Files:
- Select your source, target, and property files using the file input fields provided.
- Ensure that your source and target files are in either .xlsx or .xls format, and your property file is in .properties format.
-
Property File:
- The property file should contain properties such as
sourceColumnsandtargetColumns. - Example:
sourceColumns=Name, Address, Age targetColumns=Name, Address, Age
- Create the property file using a text editor and save it with a .properties extension.
- The property file should contain properties such as
-
Compare Files:
- Click the "Compare Files" button to start the comparison process.
-
View Results:
- Once the comparison is completed, a text file (.txt) named
result_filewill be downloaded to your device. You can analyze the results from this file.
- Once the comparison is completed, a text file (.txt) named
- HTML
- CSS
- JavaScript
Contributions to this project are welcome. If you find any issues or have suggestions for improvements, feel free to create a pull request or raise an issue in the GitHub repository.
The backend component of the Excel Comparison Tool is hosted in a separate repository. You can find the backend code and related documentation at Excel-Comparison.
Copyright © 2024 Akshay Tadakod. All Rights Reserved.