XenoGuard Documentation

Add Sheet

Actions » Windows » File Handling » Excel » Add Sheet

The action Add Sheet inserts a new worksheet to 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 Add Sheet action.


The action has the following input parameters:

Path Name
Specifies the Excel File where the worksheet is to be added.

Allowed Context Scopes [Fixed, Local, Globa]l
Allowed Context Types [Variable, Parameter, Enum] 
Sheet Name
The worksheet name to be added to the Excel file.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]
Column Information
Sets content and format of the column in a worksheet.

Parameters for the "Column" sub-branch:

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


The action returns the following results:

Confirms if the worksheet was successfully added or not.

Allowed Context Scope [Fixed]
Allowed Data Type [Boolean]
Path Name
The complete path of the Excel file where the worksheet was added.

Allowed Context Scope [Fixed]

Example 1 (Insert a worksheet in an Excel file):

This example places another worksheet named "archives" into an Excel file. Information details about the zip files from a specified directory are added to the worksheet. When the action is successful, the number of files added to the worksheet is then output via Write Text.

See other Excel operations:

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