Skip to main content
Go to the Studio
Excel

Set value of a row

Set value of a row

Sets the values of several cells in a specific row of an Excel tab at once.


Options​


Excel tab​

Select or enter the Excel tab where the information will be entered.

Column to enter the information​

Enter the letter of the cell's column, for example D.

Fill in the:​

Select the desired fill option:

  • Last row: Fills the value in the worksheet's last filled row.
  • Last row of column: Fills the value in the last filled row of the selected column.
  • None: Lets you specify manually the row to enter the information.

Line to enter the information​

Enter the number of the cell's row, for example 2. This field is shown only when "None" is selected in "Fill in the".

Values or Formulas​

Add one or more fields with the values or formulas to enter. Use the Add button to include new items.

Returns​

This action has no returns.

Rules and Conditions​

  • Every field is required.
  • Save the file after making changes to persist the data.