Reads a worksheet of an MS Excel file and writes the individual values to table columns in the data feed based on the specified parameters. The source table can be imported as a list or cross table.
In list tables, a corresponding column is created in the data feed for every non-empty column in the source table.
In cross tables, three columns are created in the data feed: A vertical iteration column corresponding to the first source column with the header, a horizontal iteration column defined in the operator and a value column.
MS Excel cells of data type number are extracted accurately, regardless of their formatting. Therefore, the values can be more accurate than displayed in MS Excel. MS Excel cells of data type date are extracted according to the formatting information to maintain the accuracy of the time stamp.
A cell can have a maximum of 2,000 characters.
The following parameters are available.
Parameters |
Description |
---|---|
Source |
MS Excel file (xls, xlsx)
|
Browse file (alias) |
Enables you to browse the resource directories with the alias defined. Click the Browse file alias (...) button and select the required source file. At least one resource directory must exist. For details, see Manage resource directories. |
Insert parameter ( |
Inserts user defined input parameters at the cursor position. The button is clickable only if at least one user input parameter, for example, Text user input, has been inserted in the feed definition. |
Parameter options ( |
Enables you to set input parameter options. |
Refresh rate () |
Specifies the time until the data source is read in again. Default value is 12 h. |
Authentication |
Specifies the credentials for authenticating to access the source file. Single Sign-On is preset for authentication if you select URL alias to access the source and Single Sign-On is enabled for the selected Path prefix (alias). Click Authentication if you want to change the settings. Single Sign-On: Enables you to access the source file using Single Sign-On (SSO). SSO only works within ARIS and not for files provided by external data sources, such as an external web page. For details on how to configure SSO, see Configure single sign-on. HTTP basic authentication: Specifies an HTTP basic access authentication. User name and password are required for accessing the source file. |
Sheet |
Sheet in the source table to be extracted. The default value: First sheet Specification: Mandatory |
List table / Cross table |
Specifies the table type. The default value: List table Specification: Mandatory For cross tables, only a single vertical iteration on the left side of the table is currently supported. |
Separator |
Separates the column values in the CSV file. Comma (,), semicolon (;), space, tab and pipe ((l)) are available. Default is comma. |
Column name from row |
Determines the names of the individual columns from a specific row, the row number of which must be specified. This option is not available for cross tables. |
Horizontal iteration from row |
Determines the column names of the individual iteration steps from a specific row. The column name of the vertical iteration is also determined from this row. |
Import values from row |
Extracts all values from the source file starting with a specific row. The default value: 2 Specification: Mandatory |
Import data range from/to |
Area of the table from which data is to be extracted, specified using column and row coordinates, for example, A3 to H128 Specification: Optional You can only specify a single continuous data range that can contain empty rows or columns. If no upper limit (to) is specified for the data range, all cells above the lower limit (from) are extracted. |
Configure columns |
Configures the columns list. You can unselect a column to exclude it from the result data. If you enter a new name for a column, this name is used in the result instead of the original column name. If you click Reset columns, the column list is reloaded from the data source and all changes in the list are undone. |
If you use an absolute URL, for example, http://myhost.company:1080/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580, an authentication must be set. All requests to the uploaded file are made with the specified user/password combination.
If you use a relative URL, for example, /documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580, an authentication is not required. All requests to the uploaded file are made with the current logged in user.