export
abstract fun exportToExcel(schemaName: String? = defaultSchemaName, wbName: String = label, wbDirectory: Path = outputDirectory.excelDir)
Writes each table in the schema 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.
Parameters
schema
the name of the schema containing the tables or null
wb
the name of the workbook
wb
the directory to store the workbook
abstract fun exportToExcel(tableNames: List<String>, schemaName: String? = defaultSchemaName, wbName: String = label.substringBeforeLast("."), wbDirectory: Path = outputDirectory.excelDir)
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.
Parameters
schema
the name of the schema containing the tables or null
table
the names of the tables to write to a workbook
wb
the name of the workbook
wb
the directory to store the workbook