Skip to main content

Excel

Use these actions to work with Excel files.

Actions​

Create Excel File​

Use this action to create an Excel file. The following configuration options are available:

  • File name:
    Enter the name that the generated Excel file should have. The .xlsx file extension is automatically appended.
  • Worksheets:
    Here, you can use a button to add one or more worksheets and enter the names they should have.

This action provides the following placeholders:

  • Generated file:
    This placeholder references the created Excel file.

Initialize Excel File​

Use this action to create a copy of a provided Excel file and make it available as a placeholder. The following configuration options are available:

  • File:
    Provide the file placeholder that should be copied as the source.
  • File name (optional):
    Optionally enter a name for the copy. If no file name is provided, the original name of the provided file is used.

This action provides the following placeholders:

  • Generated file:
    This placeholder references the copy of the provided file.

Delete Excel Worksheet​

Use this action to delete a worksheet from an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder from which the worksheet should be deleted.
  • Worksheet:
    Enter the name of the worksheet that should be deleted.

Add Excel Worksheet​

Use this action to add a worksheet to an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder to which a worksheet should be added.
  • Worksheet name:
    Enter the name of the worksheet that should be added.
  • Position:
    Select whether the worksheet should be inserted at the beginning or appended at the end.

Read Excel Worksheets​

Use this action to read all worksheets from an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder from which the worksheets should be read.

This action provides the following placeholders:

  • Worksheets:
    This placeholder provides a list of all worksheet names in the file and can also be iterated in a loop.

Create Excel Table​

Use this action to create a table in an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder in which the table should be created.
  • Worksheet name:
    Enter the name of the worksheet on which the table should be created.
  • Table name:
    Enter the name that should be assigned to the table.
  • Column names:
    Enter the column names that should be added to the table.
  • Position:
    Enter the position where the table should start.

Extend Excel Table​

Use this action to extend a table with the specified columns. The following configuration options are available:

  • File:
    Provide the file placeholder in which the table should be extended.
  • Table name:
    Enter the name of the table that should be extended with columns.
  • Columns:
    Enter the columns that should be added to the table.

Delete Excel Table​

Use this action to delete a table from an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder from which the table should be deleted.
  • Table name:
    Enter the name of the table that should be deleted.

Delete Excel Table Rows​

Use this action to delete table rows from a table. The following configuration options are available:

  • File:
    Provide the file placeholder in which the table is located.
  • Table name:
    Enter the name of the table from which rows should be deleted.
  • Column name:
    Enter the column name in which the search value should be matched.
  • Search value:
    Enter the search value. All rows are deleted where the column value exactly matches this search value. If the search value is empty, rows with an empty column value are deleted.

Add Excel Cell Comment​

Use this action to add a comment to a cell. The following configuration options are available:

  • File:
    Provide the file placeholder in which the comment should be added.
  • Worksheet name:
    Enter the name of the worksheet.
  • Cell:
    Enter the cell to which the comment should be added.
  • Comment:
    Enter the comment that should be added.

Delete Excel Cell Comment​

Use this action to delete a comment from a cell. The following configuration options are available:

  • File:
    Provide the file placeholder from which the comment should be deleted.
  • Worksheet name:
    Enter the name of the worksheet.
  • Cell:
    Enter the cell from which the comment should be deleted.

Read Excel Tables​

Use this action to read all table names from an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder from which tables should be read.
  • Worksheet name (optional):
    Optionally enter the name of the worksheet from which tables should be read.

This action provides the following placeholders:

  • Tables:
    This placeholder provides a list of table names and can also be iterated in a loop.

Read Excel Table Columns​

Use this action to read all column names from a table. The following configuration options are available:

  • File:
    Provide the file placeholder from which the column names should be read.
  • Table name:
    Enter the name of the table from which the column names should be returned.

This action provides the following placeholders:

  • Columns:
    This placeholder provides a list of the column names of the specified table and can also be iterated in a loop.

Read Excel Table Rows​

Use this action to read all rows from a table. The following configuration options are available:

  • File:
    Provide the file placeholder from which the rows should be read.
  • Table name:
    Enter the name of the table from which the rows should be read.
  • Columns:
    Enter the columns that should be loaded. For each entry, define the column name and the expected data type.

This action provides the following placeholders:

  • Rows:
    This placeholder provides the loaded rows and can also be iterated in a loop.

Read Excel Cell Value​

Use this action to read the value of a cell from an Excel file. The following configuration options are available:

  • File:
    Provide the file placeholder from which the cell value should be read.
  • Worksheet name:
    Enter the name of the worksheet.
  • Cell:
    Enter the cell that should be read.
  • Expected data type:
    Select the expected data type of the cell value.

This action provides the following placeholders:

  • Cell value:
    This placeholder provides the read cell value. Based on the expected data type, the placeholder is displayed dynamically.

Add Excel Table Row​

Use this action to add a new entry at the end of a table. The following configuration options are available:

  • File:
    Provide the file placeholder to which the row should be added.
  • Table name:
    Enter the name of the table to which the row should be added.
  • Column pairs:
    Enter one or more pairs consisting of column name and value that should be added as the new table row.

Update Excel Table Rows​

Use this action to update specific rows in a table. The following configuration options are available:

  • File:
    Provide the file placeholder in which the table rows should be updated.
  • Table name:
    Enter the name of the table in which rows should be updated.
  • Filter column name:
    Enter the column name used to select the rows that should be updated.
  • Filter value:
    Enter the search value used to identify the rows that should be updated.
  • Column pairs:
    Enter one or more pairs consisting of column name and value. In each selected row, the specified columns are updated with the corresponding value.

Update Excel Cell Value​

Use this action to update the value of a cell. The following configuration options are available:

  • File:
    Provide the file placeholder in which the cell value should be updated.
  • Worksheet name:
    Enter the name of the worksheet.
  • Cell:
    Enter the cell that should be updated.
  • Value:
    Enter the value that should be inserted.

Set Excel Cell Formula​

Use this action to set a formula in a cell. The following configuration options are available:

  • File:
    Provide the file placeholder in which the formula should be set.
  • Worksheet name:
    Enter the name of the worksheet.
  • Cell:
    Enter the cell in which the formula should be set.
  • Formula:
    Enter the formula that should be set.