ExcelDataProvider

---

Via the ExcelData provider Excel files can be accessed.

Configuration

In addition to the Mapping and SearchParameters configuration, which all DataProviders of the Data interface require, the ExcelDataProvider can be configured via the Option element:

<ExcelDataProvider DisplayName="Customer addresses">
  <Options>
    <FilePath>\\fileshare\addressdata.xlsx</FilePath>
    <HasHeaders>true</HasHeaders>
    <SheetName>Data</SheetName>
  </Options>
    ...
</ExcelDataProvider>

• FilePath string, path to xlsx file
• HasHeader bool, indication whether first row is a header row
  If there are no headers, the columns will be counted up as in Excel (A, B, ...) (important for SearchParameters and Mapping).
• Delimiter string, indication of the delimiter

Example

<ExcelDataProvider DisplayName="Customer addresses">
  <Options>
    <FilePath>\\fileshare\addressdata.xslx</FilePath>
    <HasHeaders>true</HasHeaders>
    <SheetName>Data</SheetName>
  </Options>
  <SearchParameters>
    <Text Id="Firma" Label="Firmenname" />
    <Text Id="Ort" Label="Ort" />
  </SearchParameters>
  <Mapping>
    <Map Source="Firma" Target="CompanyName" />
    <Map Source="Strasse" Target="Street" />
    <Map Source="PLZ" Target="PostalCode" />
    <Map Source="Ort" Target="City" />
    <Map Source="Land" Target="Country" />
  </Mapping>
</ExcelDataProvider>