# xlsx (importer)

Imports Excel Spreadsheets where each line is a token, the other columns are
spans and merged cells can be used for spans that cover more than one token.

## Configuration

###  column_map

Maps token columns to annotation columns. If there is more than one
token column, it is assumed that the corpus has multiple segmentations.
In this case, it is necessary to tell the importer which annotation column belongs to which token column.

Example with the two token columns "dipl" and "norm":

```toml
[import.config]
column_map = {"dipl" = ["sentence"], "norm" = ["pos", "lemma", "seg"]}
```
The column "sentence" must be always be aligned with the "dipl" token
and "pos", "lemma" and "seg" are aligned with the "norm" token.

###  fallback

If given, the name of the token column to be used when there is no
explicit mapping given in the `column_map` parameter for this annotation
column.

Example with two token columns "dipl" and "norm", where all annotation
columns except "lemma" and "pos" are mapped to the "dipl" token column:

```toml
[import.config]
column_map = {"dipl" = [], "norm" = ["pos", "lemma"]}
fallback = "dipl"
```

###  datasheet

Optional value of the Excel sheet that contains the data. If not given,
the first sheet is used.

###  metasheet

Optional value of the Excel sheet that contains the metadata table. If
no metadata is imported.

###  metasheet_skip_rows

Skip the first given rows in the meta data sheet.

###  token_annos

Map the given annotation columns as token annotations and not as span if possible.

###  evaluate

If formulas should be evaluated (false by default), set this to true. If false,
a cell entry will be treated as text value including the `=`.

