XenoGuard Documentation

Create File

Actions » Windows » File Handling » Excel » Create File

The action Create File generates a spreadsheet in Excel file format. Adding details in the Column Information sets the column headers 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 Create File action.

Parameters:

The action has the following input parameters:


NAME DESCRIPTION
Output Path
Specifies the directory where the Excel file is created.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]
Sheet Name
The initial worksheet name when the Excel file is created.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types Variable, Parameter, Enum]
File Name
The name of the Excel file to be created.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]
Column Information
Sets content and format of the column header 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]

Warning An exception error occurs when values for the Alignment, Font, Fore Color, and/or Back Color are not set from the fixed value.

Results:

The action returns the following results:


NAME
DESCRIPTION
Result
Confirms if the Excel file was successfully created or not.

Allowed Context Scopes [Fixed]
Allowed Data Types [Boolean]
Path Name
The complete path of the created Excel file.

Allowed Context Scopes[Fixed]

Example 1 (Add contents to a newly created Excel File):

This example generates a new Excel file that contains information about the text files from a specified folder. When the action is successful, a notice on the number of added files is then output via Write Text.


See other Excel operations:

Get Sheet Information
Add Sheet
Rename Sheet
Delete Sheet
Insert Data
Update Data
Get Data
Format Cells
Clear Cells
Delete Cells