XenoGuard Documentation

Insert Data

Actions » Windows » File Handling » Excel » Insert Data

The action Insert Data adds content data to a specified worksheet of an existing 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 Insert Data action.

Parameters:

The action 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] 
Sheet Name
The name of the worksheet where data is to be inserted.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]
Iteration
The number of iterations before the file is updated.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]
Values
The record or data to be inserted into the rows in an Excel worksheet.

Parameters for the "Values" sub-branch:

  • Column - the column where data is to be inserted
  • Value - the record or data to be inserted
  • 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 action returns the following results:


NAME
DESCRIPTION
Result
Confirms if the record or data was added to the worksheet or not.

Allowed Context Scope [Fixed]
Allowed Data Type [Boolean]

Information When Column is set to "Auto", the record or data is inserted to the next available row in the worksheet.
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 (Enter records into a worksheet):

This example inserts information about the text files inside a specified folder into a worksheet. When the information is successfully inserted into the Excel file, a notice is displayed via Write Text.


See other Excel operations:

Create File
Get Sheet Information
Add Sheet
Rename Sheet
Delete Sheet
Update Data
Get Data
Format Cells
Clear Cells
Delete Cells