writeSheetToCSV

fun writeSheetToCSV(sheet: Sheet, numCol: Int = numberColumnsForCSVHeader(sheet), skipFirstRow: Boolean = false, pathToCSV: Path = KSL.outDir.resolve("${sheet.sheetName}.csv"), maxChar: Int = DEFAULT_MAX_CHAR_IN_CELL)

Treats the columns as fields in a csv file, writes each row as a separate csv row in the resulting csv file

Parameters

sheet

the sheet to write, must not be null

skipFirstRow

if true, the first row is skipped in the sheet

pathToCSV

a Path to the file to write as csv, must not be null

numCol

the number of columns to write from each row, must be at least 1

maxChar

the maximum number of characters that can be in any cell, must be at least 1

Throws

an IO exception