Working with Time Function Formulas

15 Dec 20201 minute to read

Time Function Formulas includes the following functions:

  • NOW
  • TODAY

NOW Function

NOW Function is used to returns the serial number of the current date and time.

The following code snippet illustrates on how to use NOW function formula.

  • dart
  • // Create a new Excel Document.
    final Workbook workbook = Workbook();
    
    // Accessing sheet via index.
    final Worksheet sheet = workbook.worksheets[0];
    
    // Formula calculation is enabled for the sheet.
    sheet.enableSheetCalculations();
    
    // Setting formula in the cell.
    final Range range = sheet.getRangeByName('A1');
    range.setFormula('=NOW()');
    double.parse(range.calculatedValue).toStringAsFixed(2);
    range.numberFormat = 'm/d/yyyy h:mm';
    
    // Save and dispose workbook.
    final List<int> bytes = workbook.saveAsStream();
    File('NOWFunction.xlsx').writeAsBytes(bytes);
    workbook.dispose();

    TODAY Function

    TODAY Function is used to returns the serial number of the current date.

    The following code snippet illustrates on how to use TODAY function formula.

  • dart
  • // Create a new Excel Document.
    final Workbook workbook = Workbook();
    
    // Accessing sheet via index.
    final Worksheet sheet = workbook.worksheets[0];
    
    // Formula calculation is enabled for the sheet.
    sheet.enableSheetCalculations();
    
    // Setting formula in the cell.
    final Range range = sheet.getRangeByName('A1');
    range.setFormula('=TODAY()');
    range.numberFormat = 'mm/dd/yyyy';
    
    // Save and dispose workbook.
    final List<int> bytes = workbook.saveAsStream();
    File('TODAYFunction.xlsx').writeAsBytes(bytes);
    workbook.dispose();