With the help of this endpoint it is possible to export objects from geodatabase into an Excel file with an Excel template. Different attributes can be exported from the UT XML file with the help of an XSL file. The resulting XML file must have the following format:
<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>
The values are written to the corresponding cells of the template which is then stored as a new file, under a certain path. Cells that already contain values are overridden.
Parameter |
Value |
Required |
|---|---|---|
Name |
Service Endpoint name. |
X |
Type |
Endpoint Service type. The value should be "Excel Inbound". |
X |
Description |
Endpoint Service description. |
|
Path to template |
Path to the Excel file that serves as a template for generating the actual Excel files. |
X |
Save in path |
Path under which the newly generated Excel files should be saved. |
X |
XSL Parameter |
Optional parameters used for UT XML format transformation. |
X |
Request XSL file |
The incoming XML is transformed into UTI XML in order to process the data. |
X |
Response XSL file |
XSL file used to transform the response XML into the response message. If this parameter is empty, a no response message is generated. |
|
Dependency ServicePoint |
This parameter describes a dependency on another service endpoint, which is called immediately after the ExcelWriter has ended. Currently, only service endpoints of the External Program type can be selected from here. This parameter is optional. |
|
