Excel Extract

image_pdfimage_print

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.

Main settings
Connection A connection of type ExcelFile
Range

 
 

The range to be extracted in the Excel file. Valid examples include the following:

  • Sheet3
  • Sheet2!$A$1:$H$10000
  • Sheet1!$A:$H

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
Header If set, the first row of the range contains the column names. Otherwise the column names will be “column1”, “column2”,…
Field Structure

The resulting field structure of the Excel extract can be generated with the Refresh option. 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.
Advanced settings
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.
image_pdfimage_print
Was this post helpful?
NoYes (0 rating, 4 votes)
Loading...