Update Data
ActionStep Reference » Windows » File Handling » Excel » Update Data
The ActionStep Excel Update Data modifies the data stored in a specified worksheet of an Excel file.
- Open the Windows node in the Workspace Explorer.
- Open the File Handling node.
- In the Excel node, select the Update Data ActionStep.
Parameters:
The ActionStep has the following input parameters:
NAME |
DESCRIPTION
|
---|---|
Path Name
|
Specifies the path of the Excel File to be updated.
Allowed Context Scopes [Fixed, Local, Global] Allowed Context Types [Variable, Parameter, Enum] |
Row
|
The target row to be updated.
Allowed Context Scopes [Fixed, Local, Global] Allowed Context Types [Variable, Parameter, Enum] |
Iterations
|
The number of iterations before the file is updated.
Allowed Context Scopes [Fixed, Local, Global] Allowed Context Types [Variable, Parameter, Enum] |
Sheet Name
|
The name of the worksheet where data is to be updated.
Allowed Context Scopes [Fixed, Local, Global] Allowed Context Types [Variable, Parameter, Enum] |
Values
|
The record or data to be updated in a cell of a specified row in an Excel worksheet.
Parameters for the "Values" sub-branch:
Allowed Context Types [Variable, Parameter, Enum] |
The Sheet Name in an Excel file is listed as fixed values of the context scopes. |
Results:
The ActionStep returns the following results:
NAME
|
DESCRIPTION
|
---|---|
Result
|
Confirms if the record or data was updated in the worksheet or not.
Allowed Context Scope [Fixed] Allowed Data Type [Boolean] |
An exception error occurs when values for the Alignment, Font, Fore Color, and/or Back Color are not set from the fixed value. |
Example 1 (Update cell content in a worksheet):
This example retrieves data from an Excel file and updates the Last Write Time column with the current Date/Time. If the update is successful, the ActionStep in the "Then" branch is executed, otherwise the ActionStep in the "Else" branch is performed. A notice of the result is then output via Message Box.
See other Excel operations:
Create File
Get Sheet Information
Add Sheet
Rename Sheet
Delete Sheet
Insert Data
Get Data
Format Cells
Clear Cells
Delete Cells