Write from data table action in Microsoft 365 Excel

Use the Write from data table action in Microsoft 365 Excel to write values from data table into a worksheet.

Settings

  • Enter the name of the session in the Microsoft 365 Excel session field that is used to open the workbook, or if you stored the session name as a variable, click Insert a value icon to select it.

    See Using the Open action.

  • Click the Enter data table variable drop-down menu to select an existing data variable.

    (Optional) If a variable is not available, click the Create variable icon.

  • Use the Enter worksheet name field to select one of the following options:
    • Active worksheet: Is the default setting and the values from the data table will be copied to the currently active worksheet.
    • Specific worksheet: Select this option if you want to specify a worksheet by selecting one of the following options:
      • Index: Enter the index number of the worksheet.
      • Name: Enter the name of the worksheet.
  • Use the Specify the first cell field to enter the first cell from where data must be written.

    For example, if you want the values from the data table to be written from the fifth row of the third column in a worksheet, enter C5.

  • Click Save.