Export data to CSV and Excel by extracting from MySQL DB tables using Scala

Export data to CSV and Excel by extracting from MySQL DB tables using Scala
This is a program written in Scala to connect to MySQL DB and extract table data and export to CSV and Excel. This is the second part of the series. The first part consits of connecting to MySQL DB and extracting the data and writing in console.

01:07 Summarizing the pre -written code to connect to mysql db and reading from the table
02:18 Reading DB table column header using MetaData.
02:36 Creating a CSV file and writing the table header and table data into it
08:34 Creating and Excel file and writing the table header and table data into it using apache poi library.
09:54 Debug testing of the code

Git link of source code for Excel export: