Kotlin Spring Boot RestAPIs - Download Excel File - Apache POI + MySQL » grokonez

Kotlin Spring Boot RestAPIs - Download Excel File - Apache POI + MySQL » grokonez

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA to get data from MySQL records and uses Apache POI library to write data to a Excel file. Related posts: – Kotlin – How to read/write Excel file with Apache POI – How to use Spring JPA … Continue reading "Kotlin Spring Boot RestAPIs – Download Excel File – Apache POI + MySQL"

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-excel-file-apache-poi-mysql

Kotlin Spring Boot RestAPIs – Download Excel File – Apache POI + MySQL

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

Related posts:

Technologies

– Kotlin Spring Boot – 2.0.6.RELEASE – Spring JPA – MySQL – Apache POI

Practice

Project Structure -> kotlin-spring-boot-restapi-download-excel-file-spring-jpa-mysql-project-structure

Create Kotlin SpringBoot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:
<dependency>
    <groupId>org.jetbrains.kotlin</groupId>
    <artifactId>kotlin-stdlib-jdk8</artifactId>
</dependency>
<dependency>
    <groupId>org.jetbrains.kotlin</groupId>
    <artifactId>kotlin-reflect</artifactId>
</dependency>
<dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>               
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-data-jpa</artifactId>
      </dependency>      
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>   
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>javax.xml.bind</groupId>
    <artifactId>jaxb-api</artifactId>
    <version>2.3.0</version>
</dependency>

Customer Model

Customer.kt ->

More at:

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-excel-file-apache-poi-mysql

Kotlin Spring Boot RestAPIs – Download Excel File – Apache POI + MySQL

kotlin springboot restapi excel mysql apachepoi

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

SpringBoot RestAPI Upload Excel file to MySQL/PostgreSQL - loizenai.com

I guide how to implement "SpringBoot & Excel file Upload/Download - Import Data from Excel to MySQL using Spring Boot Restapi" with poi-ooxml

iText PDF + Kotlin SpringBoot RestAPI + MySQL » grokonez

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA & iText PDF library to extract data from MySQL records to a PDF file in table format. Related posts: – How to use Spring JPA MySQL | Spring Boot ContentsTechnologiesPracticeCreate Kotlin SpringBoot projectCustomer ModelJPA Customer RepositoryImplement PDF … Continue reading "iText PDF + Kotlin SpringBoot RestAPI + MySQL"

Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA to get data from MySQL records and uses Apache Commons CSV library to write data to a CSV file. Related posts: – Kotlin – How to read/write CSV file with Apache Commons CSV – Kotlin Spring JPA … Continue reading "Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL"

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Compare ScaleGrid MySQL vs. DigitalOcean Managed Databases - See which offers the best MySQL throughput, latency, and pricing on DigitalOcean across workloads.

SpringBoot RestAPIs CRUD Application with MySQL Examples

In the tutorial, I will introduce how to create a Fullstack SpringBoot RestAPIs CRUD Application to MySQL database using Spring WEB MVC framework and Spring JPA for building Backend and using Bootstrap, JQuery Ajax for building frontend client Related posts: Spring Boot Security JWT Authentication Example – MySQL/PostgreSQL + Spring JPA + RestAPIs Angular CRUD … Continue reading "SpringBoot RestAPIs CRUD Application with MySQL Examples – FullStack: Frontend (Bootstrap + Ajax JavaScript) to Backend (SpringBoot + MySQL)"