Excel Demo App

This application allows you to download an Excel template file, upload it once completed, extract its content and then insert the data into the database. If the file contains any error (invalid header, invalid extension or formatting errors for example), then it will be returned to you.

Stack

Client	Server	Database
React	Spring Boot	MongoDB
RTK Query	Apache POI
Material UI

Demo Excel file OK

Demo Excel file NOK

How to test?

First you need to clone this project.

Client

1. Go to client folder and run npm install
2. Run the app in development mode with npm start
3. Go to http://localhost:3000/
4. You can use the resources in demo-resources to help you

Server

1. Go to server folder and run mvn install
2. Update application.properties to add your MongoDB personal values
3. Start server http://localhost:8080/
4. If you need to, check the swagger http://localhost:8080/swagger-ui/index.html