The data file is a Microsoft Excel workbook.
Excel named range from which to load. The named range must be confined to a single sheet. (Note that range and sheet are mutually exclusive.)
Whether to arrange multiple segments horizontally (range-layout=”horizontal”) or vertically (range-layout=”vertical”). By default, the range layout is not specified.
Sheet from which to load. If neither sheet nor range is specified, the loader will load from the first sheet. The default is to load from the first sheet. (Note that sheet and range are mutually exclusive.)
Row from which to start loading. For example, start-row=”2” tells the loader to skip the first row. (Default=1)
Row after which to stop loading. (Default=end of data or first empty row)
Whether to skip hidden rows. (Default=true)
treat-missing-trailing-fields-as-null
Whether to treat missing trailing fields (files with fewer fields than defined in the load specification) as null values instead of errors. (Default=false)
Number of rows between each record in the file. Generally defined only for files containing multiple data pivots. (Default=1)