excel

Load data from a specific sheet of an Excel file.

Introduction

Use the excel enrichment to load data from a specific sheet of an Excel file. To load data from a whole spreadsheet, use the xlsx enrichment.

Creating the enrichment

For more information on creating an enrichment, see Using custom scripts.

Configuring the enrichment

To configure the enrichment, fill in the following fields. Required fields are marked with an asterisk (*).

Sheet

Enter the name of the sheet of the Excel file from which to load data.

Row_Offset

Enter the row number from which to start loading data from the sheet. Data from rows with the same or lower row number is not loaded.

Column_Offset

Enter the column number from which to start loading data from the sheet. Data from columns with the same or lower column number is not loaded.

Subtable

Enter the name for a subtable that you want to contain the enriched data. The enrichment is applied to the whole data extract, then the enriched data is output into the subtable you have named here.

This subtable is a temporary table, which means it only exists for this custom script. You can apply additional instructions within the same custom script to the subtable. However, the subtable cannot be used in any other custom scripts.