KSLCore/ksl.utilities.io/ExcelUtil/exportTablesToExcel

exportTablesToExcel

fun exportTablesToExcel(db: DatabaseIfc, path: Path, tableNames: List<String>, schemaName: String?)

Writes each table in the list to an Excel workbook with each table being placed in a new sheet with the sheet name equal to the name of the table. The column names for each table are written as the first row of each sheet.

Uses the longLastingConnection property for the connection.

Parameters

schemaName

the name of the schema containing the tables or null

tableNames

the names of the tables to write to a workbook

path

the path to the workbook

db

the database containing the tables