Skip to main content

Get help for ARIS

Excel

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.

Character limit

A cell can have a maximum of 2,000 characters.

Maximum size of an Excel source file

An Excel source file is limited to:

  • XLS 80 MB

  • XLSX 9 MB

The following parameters are available.

Parameters

Description

Source

MS Excel file (xls, xlsx)

  • URL: HTTP address of the source file

    If another operator supplies the URL dynamically, the URL cannot be edited here.

    Example 174.

    Example

    https://myhost.company:1080/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1



  • URL alias: Alias of a URL configuration. Only URL aliases for that you have the Usage privilege are available. Select a URL alias. For details, see Manage URL aliases.

  • File alias: Loads file from a resource directory. Files must be located in a defined resource directory on the server.

    Path prefix (alias): Alias of the resource directory with the path to a directory on the server. Select an alias of the local resource directory.

    In the input box, enter a path to the relevant data source file for the Path prefix (alias) selected.

    Example 175.

    Example



    /documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1

Insert dynamic value (CTRL + Space)

Inserts a dynamic value into the URL using an ARIS parameter. Place the cursor in the URL, press CTRL + Space and select a parameter from the list.

You can specify the parameters, for example the default value. Click ARIS parameters in the editor header > Configure.

Settings

Displays additional options.

  • Shared caching

Enables the use of a shared cache when multiple users access the same document. This option is available if you specified a document as a data source that is deployed in ARIS Document Storage (ADS). The option is enabled by default. If you disable the option, you must specify HTTP basic authentication instead.

  • HTTP basic authentication

Specifies an HTTP basic access authentication.

User name and password are required for accessing the source file.

The option is available, if you disable Shared caching.

  • Refresh rate

Specifies the time until the data source is read in again. Default value is 12 h.

  • HTTP headers

Adds HTTP headers to the URL.

Click + Add header and specify HTTP headers.

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.

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

Data range

Enables the import of data from a data range in the table.

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.

The option is available if you enabled the Data range option.

Columns

List of data source columns. Click Edit Column configuration to configure the columns list. Deselect a column to exclude it from the result data. If you enter a New name for a column, it is used instead of the original column name in the result. If you click Reset columns, the column list is reloaded from the data source and all changes in the list are undone.

Click Detect to automatically read the columns of the data source. The requested columns lists are displayed, based on the specified repeating object.

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.