writeDatacatAsExcel static method

Future<void> writeDatacatAsExcel(String path, Datacat datacat)

Writes a Datacat to an Excel file.

Creates a new Excel workbook with a single sheet named "Sheet1".

Implementation

static Future<void> writeDatacatAsExcel(String path, Datacat datacat) async {
  var excel = Excel.createExcel();
  Sheet sheet = excel['Sheet1'];
  // Write the header row.
  sheet.appendRow(datacat.columns.cast<CellValue?>());
  // Write each data row.
  for (var row in datacat.rows) {
    // Cast each row to List<CellValue?>.
    sheet.appendRow(row.cast<CellValue?>());
  }
  final fileBytes = excel.encode();
  if (fileBytes != null) {
    final file = File(path);
    await file.writeAsBytes(fileBytes, flush: true);
  }
}