Skip to main content
Version: 4.1 (2026 H2)

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. A single worksheet is read from the selected workbook.

ℹ️ 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 worksheet in the Excel file. If not defined or if the worksheet is not found, the first worksheet is used automatically. For CSV files this attribute is ignored.
  • EnableCustomSheetSelection (true/false): Displays a drop-down menu to the user for manual selection of the worksheet.
  • 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 dialog if all fields can be mapped automatically, i.e. if the columns in the Excel file match the configured Mapping or Schema.

Interplay with Mapping and Schema​

As with the other providers, the imported columns are mapped to the Schema of the Object or ObjectCollection via a Mapping. If all schema fields can be mapped automatically based on the column headers, the mapping dialog can be skipped with SkipMappingIfComplete="true"; otherwise the user performs the mapping in the mapping dialog.