Excel Resource Configuration
Before you configure your scanner, make sure you meet the prerequisites. Read our guide on Excel integration requirements to double-check.
Source System Properties
This configuration can be setup by creating a new connection on Admin UI > Connections tab or editing an existing connection in Admin UI > Connections > Reporting & BI > Excel > specific connection. New connection can also be created via Manta Orchestration API General Walkthrough Example.
| Property name | Description | Example |
|---|---|---|
| excel.dictionary.id | Name of the Excel folder to be analyzed | template |
Common Scanner Properties
This configuration is common for all Excel source systems and for all Excel scenarios, and is configure in Admin UI > Configuration > CLI > Excel > Excel Common. It can be overridden on individual connection level.
| Property name | Description | Example |
|---|---|---|
| excel.input.dir | Directory with manually provided Excel folders (for the analysis phase) | ${manta.dir.input}/excel/${excel.dictionary.id} |
| filepath.lowercase | Whether paths to files should be lowercase (false for case sensitive file systems, true otherwise) | true |