---
title: "Configuration"
manual: "Calien - XLS Exporter"
version: "5.1"
permalink: "https://docs.typo3.org/permalink/calien/xlsexport:configuration@5.1"
source: "Configuration/Index.rst"
rendered: "2026-11-19T10:49:27+00:00"
---

# Configuration {#configuration}

Exports are configured in page TSconfig below `mod.web_xlsexport`. Every direct sub-key is one
export offered by the backend module; the key is also used to reference the export internally:

**EXT:my_extension/Configuration/page.tsconfig**

```typoscript
mod.web_xlsexport {
    # "orders" is the export key
    orders {
        label = Orders of this page
        table = tx_myext_order
        select {
            10 = uid
            20 = order_number
        }
        fieldLabels {
            10 = ID
            20 = Order number
        }
    }
}
```

Each definition is translated one-to-one into a TYPO3
[QueryBuilder](https://docs.typo3.org/m/typo3/reference-coreapi/13.4/en-us/ApiOverview/Database/DoctrineDbal/QueryBuilder/Index.html#database-query-builder) query: values are bound with
`QueryBuilder::createNamedParameter()` and column names are quoted with
`QueryBuilder::quoteIdentifier()`.

> [!NOTE]
> The record count shown next to each export in the module is derived automatically from the same
> definition — the export's `table`, filters and joins are reused — so no separate counting query
> is configured.

-   [Export options](https://docs.typo3.org/permalink/calien/xlsexport:export-options@5.1)
-   [Filtering rows](https://docs.typo3.org/permalink/calien/xlsexport:filtering-rows@5.1)
-   [Joining tables](https://docs.typo3.org/permalink/calien/xlsexport:joining-tables@5.1)
-   [Complete example](https://docs.typo3.org/permalink/calien/xlsexport:complete-example@5.1)
