Importing Excel Data

Reading data from an excel file is helpful for mass data and for data that is changing frequently and provided by domain experts. To import datasets from an excel file use its first sheet and organize the data as a matrix starting in Cell A1.

The matrix is defined by its upper left cell (the "root cell") - per default the cell A1. All neighbouring non-emtpy cells to the right of the root cell belong to the "first row" of the matrix until the first emtpy cell is detected. All neighbouring non-emtpy cells below the root cell belong to the "first column" of the matrix until the first emtpy cell is detected. The whole matrix is defined by the rectangle constructed by the first row and the first column.

For example:

 |A                    |B         |C                                   |D                               |
1|Datasets in rows     |SearchText|FirstExpectedSearchResultText       |SecondExpectedSearchResultText  |
2|GoogleSearchDataset_1|SysNat    |https://github.com/iks-github/SysNat|Operate your software system    |
3|GoogleSearchDataset_2|IKS GmbH  |https://www.iks-gmbh.com            |Individuelle Softwareentwicklung|

Per default, datasets are organized in rows. That means, dataset names are supposed to be represented by the first column. The content of the root cells allows to indicate the opposite, i.e. datasets are organized in columns and the dataset names are read from the first row. To use the later organisation form write 'rotate' or 'datasets in columns' into the root cell.

For example:

 |A                             |B                                   |C                               |
1|Datasets in columns           |GoogleSearchDataset_1               |GoogleSearchDataset_2           |
2|SearchText                    |SysNat                              |IKS GmbH                        |
3|FirstExpectedSearchResultText |https://github.com/iks-github/SysNat|https://www.iks-gmbh.com        |
4|SecondExpectedSearchResultText|Operate your software system        |Individuelle Softwareentwicklung|

---

Back to User Guide