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.

[+] How to add the Update Data ActionStep to the ActionScript:

[-] Hide

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

	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