Java – Convert Excel File to/from CSV File – using Commons-CSV + Apache POI

In the tutorial, Grokonez shows how to convert Excel File to CSV File and vice versa with Java language by examples.

Continue reading “Java – Convert Excel File to/from CSV File – using Commons-CSV + Apache POI”

Java – Convert Excel File to/from JSON (String/File) – using Apache Poi + Jackson

In the tutorial, Grokonez shows how to convert Excel File to JSON String or JSON File and vice versa with Java language by examples.

– Excel Files: Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms
– JSON stands for JavaScript Object Notation. JSON is a lightweight format for storing and transporting data. JSON is often used when data is sent from a server to a web page.

Continue reading “Java – Convert Excel File to/from JSON (String/File) – using Apache Poi + Jackson”

Excel File – Upload/Download using Apache POI + SpringBoot RestAPIs + Spring JPA + Thymeleaf to MySQL

In the post, Grokonez guides how to Upload/Download Excel Files to MySQL database using SpringBoot + Spring JPA with Apache POI library

Continue reading “Excel File – Upload/Download using Apache POI + SpringBoot RestAPIs + Spring JPA + Thymeleaf to MySQL”

SpringBoot MVC RestAPIs – MongoDB – Export/Download Excel File using Apache POI example

In the tutorial, we show you how to create a SpringBoot RestAPIs application that uses Spring Data MongoDB to get data from MongoDB collection and uses Apache POI library to write data to a Excel file.

Related posts:
Java – How to read/write Excel file with Apache POI
How to use SpringData MongoRepository to interact with MongoDB
SpringBoot – Upload/Download MultipartFile to FileSystem – Bootstrap 4 + JQuery Ajax

Continue reading “SpringBoot MVC RestAPIs – MongoDB – Export/Download Excel File using Apache POI example”

SpringBoot MVC RestAPIs – PostgreSQL – Download Excel File using Apache POI example

In the tutorial, we show you how to create a SpringBoot RestAPIs application that uses Spring JPA to get data from PostgreSQL records and uses Apache POI library to write data to a Excel file.

Related posts:
Java – How to read/write Excel file with Apache POI
How to use Spring JPA with PostgreSQL | Spring Boot
SpringBoot – Upload/Download MultipartFile to FileSystem – Bootstrap 4 + JQuery Ajax

Continue reading “SpringBoot MVC RestAPIs – PostgreSQL – Download Excel File using Apache POI example”