Export data to Excel by extracting from MySQL DB tables using Kotlin

Export data to Excel by extracting from MySQL DB tables using Kotlin

This is a program written in Kotlin to connect to MySQL DB and extract table data and export to Excel . This is the second part of the series. The first part consits of connecting to MySQL DB and extracting the data and exporting to CSV.

00:53 Creating a Kotlin Project with Maven Dependency in Intellij Idea IDE
01:19 Add MySQL and apache poi into library and install using maven.
03:59 Write the code
21:34 Execute the code and check the CSV output files