Welcome to the Excel Interface Manual
ADONIS provides a configurable Excel interface for quick data acquisition. Via the Excel interface, you can import repository objects with their attributes and relations from an Excel file (XLS or XLSX format). For this process, the structure of the Excel file is described in an XML configuration file.
In this part of the manual, you will learn how to use the Excel interface. The following topics are outlined:
Structure of the Excel File: An overview of the structure of an Excel file for importing objects
Create Configuration: Learn how to create an XML configuration file which contains the mapping of objects from the Excel file to the ADONIS metamodel.
Perform Excel Import: Learn how to import objects from Excel
To successfully create a configuration, you need access to the Metamodel Management. The language independent name of object types, attributes etc. can be found there and you need those for the configuration.