You can import data from Excel workbooks with an Excel extract.
Note: formulas are only evaluated for files in the XLSX format but not for files in the WSS format.
|Connection:||A connection of type ExcelFile|
The range to be extracted in the Excel file. Valid examples include the following:
If not set, the first sheet in the workbook is used, starting in the first non-empty row up to subsequent first empty row. The non-empty columns of the first non-empty row determine the columns of the range.
|Range column subset:||An optional list of comma-separated column indices that will be extracted. Index 1 indicates the first column of the range. Example: 1,3,4|
Check this option if the first row of the range contains the column names. If not, leave it unchecked and the column names will be “column1”, “column2”,…
Note: extraction of data from Excel files with merged headers is not supported.
The resulting field structure of the Excel extract can be generated with the Refresh button. The number and the (original) name of all columns are displayed. For each column you can then optionally define the following settings:
|FieldName:||An alternative name to the original name of the column. The field will be referenced with this name for the rest of the Jedox Integrator process.|
|Default:||This setting defines a first basic mapping. A blank, several blanks, or a null value is mapped to this default value.|
|Types from First Row||If set, the data types (string, numeric, date) are taken from the cell formats in the first row of the Excel workbook range. Otherwise the data type is always set to string.|
|Target Date Format||Workbook cells formatted as date will be output in this date format. Details on Syntax in DateFormat Function.|
|Use Caching||Memory, disk, or none (default). For more information, see Caching in Extracts.|