celulaText method

dynamic celulaText({
  1. required Worksheet sheet,
  2. required int linha,
  3. required int coluna,
  4. required Style style,
  5. required dynamic text,
  6. bool? autoFitColumns,
  7. bool? laguraFixa,
  8. bool? larguraTitulo,
})

Implementation

celulaText({required Worksheet sheet, required int linha, required int coluna, required Style style, required text, bool? autoFitColumns, bool? laguraFixa, bool? larguraTitulo}) {
  sheet.getRangeByIndex(linha, coluna).cellStyle = style;
  Range range = sheet.getRangeByIndex(linha, coluna);
  if (larguraTitulo ?? false) {
    range.setText('$titulo$titulo------------'); //forçar primeira celula ficar com a largura do titulo
    range.autoFitColumns();
    range.setText(text);
  }

  if (laguraFixa ?? false) {
    range.setText('-------------'); //forçar uma largura fixa
    range.autoFitColumns();
    range.setText(text);
  } else {
    range.setText(text);
  }

  if (!(larguraTitulo ?? false)) if (!(laguraFixa ?? false)) if (autoFitColumns ?? true) range.autoFitColumns();
}