Working with Text Function Formulas

3 Feb 20213 minutes to read

Text Function Formulas includes the following functions:

  • CONCATENATE
  • TRIM
  • LOWER
  • UPPER

CONCATENATE Function

CONCATENATE Function is a Text Function used to join two or more text strings into one string.

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

  • dart
  • // Create a new Excel Document.
    final Workbook workbook = Workbook();
    
    // Accessing sheet via index.
    final Worksheet sheet = workbook.worksheets[0];
    
    // set the value to the cell.
    sheet.getRangeByName('A1').setText('Syncfusion ');
    sheet.getRangeByName('A2').setText('Software');
    
    sheet.getRangeByName('B1').setText('Hello');
    sheet.getRangeByName('B2').setText('World');
    
    // Formula calculation is enabled for the sheet.
    sheet.enableSheetCalculations();
    
    // Setting formula in the cell.
    Range range = sheet.getRangeByName('A4');
    range.setFormula('=CONCATENATE(A1,A2)');
    range = sheet.getRangeByName('A6');
    range.setFormula('=CONCATENATE(B1,B2)');
    
    // Save and dispose workbook.
    final List<int> bytes = workbook.saveAsStream();
    File('CONCATENATEFunction.xlsx').writeAsBytes(bytes);
    workbook.dispose();

    TRIM Function

    TRIM Function is used to removes all spaces from text except for single spaces between words.

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

  • dart
  • // Create a new Excel Document.
    final Workbook workbook = Workbook();
    
    // Accessing sheet via index.
    final Worksheet sheet = workbook.worksheets[0];
    
    // set the value to the cell.
    sheet.getRangeByName('A1').setText('   Hello  ');
    sheet.getRangeByName('A2').setText('     World  Hi');
    
    // Formula calculation is enabled for the sheet.
    sheet.enableSheetCalculations();
    
    // Setting formula in the cell.
    Range range = sheet.getRangeByName('A4');
    range.setFormula('=TRIM(A1)');
    range = sheet.getRangeByName('A6');
    range.setFormula('=TRIM(A2)');
    
    // Save and dispose workbook.
    final List<int> bytes = workbook.saveAsStream();
    File('TRIMFunction.xlsx').writeAsBytes(bytes);
    workbook.dispose();

    LOWER Function

    LOWER Function used to converts all uppercase letters in a text string to lowercase.

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

  • dart
  • // Create a new Excel Document.
    final Workbook workbook = Workbook();
    
    // Accessing sheet via index.
    final Worksheet sheet = workbook.worksheets[0];
    
    // set the value to the cell.
    sheet.getRangeByName('A1').setText('HELLO');
    sheet.getRangeByName('A2').setText('World HI');
    
    // Formula calculation is enabled for the sheet.
    sheet.enableSheetCalculations();
    
    // Setting formula in the cell.
    Range range = sheet.getRangeByName('A4');
    range.setFormula('=LOWER(A1)');
    range = sheet.getRangeByName('A6');
    range.setFormula('=LOWER(A2)');
    
    // Save and dispose workbook.
    final List<int> bytes = workbook.saveAsStream();
    File('LOWERFunction.xlsx').writeAsBytes(bytes);
    workbook.dispose();

    UPPER Function

    LOWER Function used to converts all lowercase letters in a text string to uppercase.

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

  • dart
  • // Create a new Excel Document.
    final Workbook workbook = Workbook();
    
    // Accessing sheet via index.
    final Worksheet sheet = workbook.worksheets[0];
    
    // set the value to the cell.
    sheet.getRangeByName('A1').setText('hello');
    sheet.getRangeByName('A2').setText('World hi');
    
    // Formula calculation is enabled for the sheet.
    sheet.enableSheetCalculations();
    
    // Setting formula in the cell.
    Range range = sheet.getRangeByName('A4');
    range.setFormula('=UPPER(A1)');
    range = sheet.getRangeByName('A6');
    range.setFormula('=UPPER(A2)');
    
    // Save and dispose workbook.
    final List<int> bytes = workbook.saveAsStream();
    File('UPPERFunction.xlsx').writeAsBytes(bytes);
    workbook.dispose();