Updates the values in an Excel file for one or more cells.
Overview
This procedure updates the contents of one or more specific cells in an Excel file. You specify the worksheet, the target cell references (e.g., "A1", "B2"), and the new values for the cells.
Prerequisite Data
These required data elements must be present in the automation before using the procedure.
Data Name
Data Type
the excel
Excel File
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
set the cell values in the excel
What does it do?
Starts the instruction to update specific cells in the Excel file.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
⛔ No — This phrase does not require input data.
the worksheet name is
What does it do?
Specifies which worksheet in the Excel file to update.
Where does it go?
This phrase should be indented beneath set the cell values in the excel.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the cell references are
What does it do?
Lists the cells to update. Must be valid Excel-style references such as "A1", "B2", "C3".
Where does it go?
This phrase should be indented beneath set the cell values in the excel.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the cell values are
What does it do?
Lists the values to assign to the specified cells. The number of values must match the number of cell references.
Where does it go?
This phrase should be indented beneath set the cell values in the excel.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
Examples
1. Update Multiple Cell Values
set the cell values in the excel
the worksheet name is "Standard Status"
the cell references are "C9", "C12", "J2"
the cell values are "Completed", "In Progress", "Pending Approval"
