Import data from Excel

Updated 2 years ago by Daniel Kroiß

Import data from Excel

Structure of the Excel file

Template: dabExporter_Excel.xlsx

Import data from Excel

In addition to SAP® tables, you can also import data from Excel.

This works similar to adding SAP® tables.

After pressing the above button, you must specify the location of the Excel file.

If your Excel file contains several tables, this is no problem.

When importing, you can select from which worksheet the data should be taken.

Then the tables are inserted in the dab:Exporter and you can save your package.

The tables contain the fields that were specified in the field REFERFELD in the Excel file.

If you now go to the area for the filters, you will see that a filter already exists there.

If you go under the tab Values, this filter has the value defined in the Excel file.

How did we do?

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)