How to convert excel data into List of Java Objects : Poiji API Almost every Java developer come across one of the most common requirement expected by the clients. The requirement is working with excel either to generate reports or to take input data from excel. As a java developer, we should be aware of the mapping between excel data & java objects. If we can have an API which can directly map excel cell to a field (property) of a java class, then it will become very easy to implement any kind of operation on excel. No surprise ! We have an API called Poiji(A Java Excel API). It is developed on top of very popular Apache POI just like Spring
Excel
How to Upload Excel data into Database Using Spring Boot ?
Many clients provide their data in the form of excel sheet and request developer to save it in your database as it is. If you ever have implemented โHow to Upload excel data into Database using Spring Bootโ, itโs good. If not, no worries!, we will learn the same in this article. In the end, you will find it very easy & fast way to get it done. In fact, once you go through the complete article you will observe that you only need to provide the location of your excel file in application.properties file. You will get the data uploaded into database by making small changes in your own entity classes only. We will not promote any hard-coding in
How to export data into Excel in a Spring Boot MVC Application?
Needless to mention, data is everything for an application. If there is no data, no need of an application. Since data is everything for an application, we need to know each & every way where & how we can import/export data. Many a time, almost every client needs the data in the form of text reports. When we talk about reports in a web application from front-end, two popular reports come into mind: Excel Report, and the PDF report. Spring Boot has an integration with Excel & PDF and offers us an API to create such type of reports easily. In this article, we are going to learn about 'How to export data into Excel in a Spring Boot MVC