ExistingListDataProvider
With the ExistingListDataProvider, users can access their own Excel files without having to enter and configure them centrally. To do this, the user selects the Excel file via file selection on their device.
ℹ️ Info For “managed” CSV or Excel files, which are stored centrally, for example, CsvDataProvider or ExcelDataProvider are more suitable.
Configuration
The ExistingListDataProvider can optionally be given a name so that users can recognize it more easily (“Excel export from CRM”), but otherwise requires no further configuration.
<ExistingListDataProvider DisplayName="Excel Export aus CRM"
DefaultSheetName="Daten" EnableCustomSheetSelection="true" AutoAddAllEntries="true"
SkipMappingIfComplete="true" />
In addition to DisplayName, the following optional attributes can be defined:
- DefaultSheetName: Name of the preselected workbook in the Excel file. If not defined, the first workbook is preselected.
- EnableCustomSheetSelection (
true/false): Displays a drop-down menu to the user for manual selection of the workbook. - AutoAddAllEntries (
true/false): Automatically adds all entries in the list so that the user does not have to select them manually. - SkipMappingIfComplete (
true/false): Skips the mapping dialogue if all columns in the Excel file match the configured mapping.