Skip to content

Latest commit

 

History

History
45 lines (29 loc) · 1.7 KB

README.md

File metadata and controls

45 lines (29 loc) · 1.7 KB
Raw

SpringBoot project for Excel processing

This SpringBoot project performs two actions on Excel files:

Excel to JSON conversion:

  • This functionality reads data from an Excel sheet and converts it into a JSON object or array.
  • The specific logic and output format will depend on your implementation.

Excel sheet splitting:

  • This functionality reads data from an Excel sheet and separates it based on a defined condition (e.g., column value).
  • The resulting data is then written to two new Excel sheets.

Getting started

Prerequisites:

  • Java 11 or greater than this version
  • Maven

Project Structure:

  • src/main/java: Contains Java code for the application.
  • src/main/resources: Contains configuration files and resources.
  • pom.xml: Defines dependencies and build configuration.
  • README.md: This file (you're reading it right now!)

Clone the repository:

  • git clone <your_repository_url>
  • Build the project:
  • mvn clean install
  • Run the application:c
The application accepts arguments through Spring Boot profiles. You can activate specific profiles based on your desired functionality:

excel-to-json: Converts the specified Excel sheet to JSON. excel-split: Splits the specified Excel sheet into two based on your criteria.

For example, to convert the sheet "Sheet1" of the file "data.xlsx" to JSON, run:

java -jar target/your-project-name.jar --spring.profiles.active=excel-to-json path/to/data.xlsx Sheet1

To split the sheet "Sheet1" of the file "data.xlsx" based on a column named "Category", with output files named "category1.xlsx" and "category2.xlsx", run:

java -jar target/your-project-name.jar --spring.profiles.active=excel-split path/to/data.xlsx Sheet1 Category