This Excel Automation Tool is a Java-based desktop application that streamlines the process of manipulating Excel files. It allows users to create and manage profiles containing operations, which perform a variety of tasks on Excel files, such as copying, splitting rows, and more. The tool provides an easy-to-use graphical user interface that simplifies the task of managing and applying these operations to Excel files. The point of the application is to convert excel files from one format to another. An otherwise tedious and time-consuming process is made simple and efficient with this tool.
Contributions and feedback are welcome. I am only a beginner at Java, so any advice or suggestions are appreciated. If you have any questions or comments, feel free to contact me.
- Create, edit, and delete profiles
- Apply multiple operations to one or more Excel files at once
- Copy columns and split rows between sheets
- Utilize Excel templates for output formatting
- Import custom templates
- Java Development Kit (JDK) 8 or higher
- An Integrated Development Environment (IDE) like IntelliJ IDEA, Eclipse, or Visual Studio Code
- Clone the repository or download the project files from GitHub.
- Import the project into your IDE.
- Install any necessary dependencies and build the project.
- Run the Main class to launch the application.
- Launch the Excel Automation Tool.
- Create a new profile or select an existing one.
- Add, edit, or remove operations for the selected profile.
- Load an Excel template or import a custom one.
- Apply the operations to your Excel file or files.
- Save the modified Excel file/s.
To contribute to this project, follow these steps:
- Fork the repository.
- Create a branch with a descriptive name (git checkout -b new-feature).
- Commit your changes (git commit -am 'Add new feature').
- Push the branch to your forked repository (git push origin new-feature).
- Create a pull request.