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
Git link of source code for CSV export: https://raw.githubusercontent.com/sub...