XenoGuard 4.0 Documentation

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.


[-] Hide
  1. Open the Windows node in the Workspace Explorer.
  2. Open the File Handling node.
  3. 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:

  • Column - the column where data is to be updated
  • Value - the record or data to be updated
  • Bold Font - determines whether the text will be bold or not
  • Font Size - the size of the text in pixels
  • Alignment - text column alignment can be General, Left, Center, Right, Fill, Justify, Center Continuous, Distributed
  • Font - the font type to be used. Lists derived from the installed fonts on a device
  • Fore Color - the foreground color of the text in the cell
  • Back Color - the background color of the cell
Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]

Information 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]

Warning 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