This endpoint is reading Excel files (XLS, XLSX) and is used for file objects are transformed into the UT XML  format and finally stored in the geodatabase. First you have to declare a comma-separated list of, which are being transformed into Excel-XML format afterward.

This format has the following structure:

<excel filename=”Test.xlsx”>
  <cell ref="Blatt1!A1" type="string">value1</cell>
<cell ref="Blatt1!A2" type="numeric">value2</cell>
  …
<cell ref="BlattN!Z2" type="date">valueN</cell>
</excel>

Every cell, that contains a value, is written tot he XML. The ref attribute contains the sheet and cell reference. The attribute type is the cell data type with the following values: string, numeric, date, boolean, and blank. A type date cell has the yyyy-MM-dd'T'HH:mm:ss pattern.

Integration process flowchart

The next step transforms the format to the UT XML format via XSLT. The XSL file can be declared at the service point with the XSL file parameter. If you click on the icon next to it, a text editor will be opened and you can edit the XSL file. After the file was successfully migrated into UT, the Excel file is moved into the archive path and is deleted from the original directory. If this should not happen, no parameter must be entered in the archive path. Here it is also possible to import multiple files at a time. This is done using the wildcard filter.

Example:

The following files should be read from C:\ drive: Test1.xlsx, Test2.xlsx, Test3.xlsx

This can be defined by specifying a wildcard pattern ''*'' in the file name: C:\Test*.xlsx

The following table shows an overview of the Excel Inbound Parameter: