celulaNumber method

dynamic celulaNumber({
  1. required dynamic sheet,
  2. required dynamic linha,
  3. required dynamic coluna,
  4. required dynamic style,
  5. required dynamic number,
  6. bool? laguraFixa,
})

Implementation

celulaNumber({required sheet, required linha, required coluna, required style, required number, bool? laguraFixa}) {
  sheet.getRangeByIndex(linha, coluna).cellStyle = style;
  Range range = sheet.getRangeByIndex(linha, coluna);
  double num;

  if (number == 'NaN') {
    number = 0.0;
  }

  if (number.runtimeType.toString() == 'double')
    num = number;
  else
    num = double.parse(number ?? '0.0');
  if (laguraFixa != null)
    range.setNumber(99999999999.999); //forçar uma largura fixa
  else
    range.setNumber(num);
  range.autoFitColumns();
  range.setNumber(num);
  range.numberFormat = '#,##0.00'; // valor formatado
}