Spring Boot: Upload/Import Excel file data into MySQL Database

The Excel file is a spreadsheet file format created by Microsoft for use with Microsoft Excel. You can use the file to create, view, edit, analyse data, charts, budgets and more. In this tutorial, I will show you how to upload/import Excel file data into MySQL Database using Spring Boot & Apache POI, then export Rest API to return Excel file from database table.

Related Posts:
Spring Boot Multipart File upload example
How to upload multiple files in Java Spring Boot
Upload/Import CSV file to MySQL Database in Spring Boot
Spring Boot: Download Excel file from MySQL database table
– Documentation: Spring Boot Swagger 3 example

Deployment:
Deploy Spring Boot App on AWS – Elastic Beanstalk
Docker Compose: Spring Boot and MySQL example

Read More

React File Upload/Download example with Spring Boot Rest Api

In this tutorial, I will show you way to build React.js File Upload example with Spring Boot Rest APIs. The React App uses Axios and Multipart File for making HTTP requests, Bootstrap for progress bar. You also have a display list of files’ information (with download url).

More Fullstack Practice:
React + Spring Boot: Pagination example
Spring Boot + React: CRUD example
Spring Boot + React: JWT Authentication with Spring Security

Run both projects in one place:
How to integrate React.js with Spring Boot

Using Template Engine:
Thymeleaf + Spring Boot: File Upload example

Read More