XenoGuard Documentation

Get Data

Actions » Windows » File Handling » Excel » Get Data

The action Get Data retrieves the content of a specified worksheet and the number of rows in 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 Get Data action.

Parameters:

The action has the following input parameters:


NAME DESCRIPTION
Path Name
Specifies the path of the Excel File.
Sheet Name
The name of the worksheet where data is to be retrieved.
Column Names Row
Specifies which row represents the names of each column.
First Row
The index value of the first row to be retrieved.
Last Row
The index value of the last row to be retrieved
First Column
The index value of the first column to be retrieved.
Last Column The index value of the last column to be retrieved.

Information The Sheet Name in an Excel file is listed as fixed values of the context scopes.
Information

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Parameter, Enum]

All values of the parameters are determined by the specified format.

Warning An error occurs when the value of the First Row and First Column is set to 0.

Results:

The action returns the following results:


NAME
DESCRIPTION
Row Count
The total number of rows from the worksheet of the Excel file.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Data Types [Variable, Parameter]
Rows
The table that contains the returned values per row.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Types [Variable, Paramater]

Warning No data will be shown when the value of the Last Index and Last Column is set to 0.

Example 1 (Retrieve data from a worksheet):

This example accesses the data stored in a worksheet after retrieving the needed row and column information. The number of rows in the worksheet is then displayed via Message Box.


See other Excel operations:

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