excel

Load data from a specific sheet of an Excel file.

Introduction

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

Creating a custom script transformation using the excel instruction

To create and configure a custom script using the excel instruction, follow these steps:

1. Create a custom script transformation.

2. In the Instructions step, select the excel instruction.

3. To configure the custom script instruction, 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 use within this custom script.

A subtable is a temporary table that 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.

If a subtable does not exist for the current custom script, the transformation is applied to the data extract, and the enriched data is output into the subtable. If the subtable already exists for the custom script, the subtable is used as the input for the transformation and optionally as the output.