Skip to content

xlsx

Excel (XLSX) Input filter for ingest_json.

Processes Excel XLSX files with openpyxl.

Configuration values:

  • worksheet (default: None): The name of the worksheet to process. If None, the default one will be used.
  • rows (default: dict): type of elements in the result list:
    • dict: elements will be dictionaries, with the keys taken from the header-row.
    • list: each resulting row will be an array values.
  • header-row (default: 0): if rows is dict, the (0-based) index of the header row. All rows before the header row will be skipped.
  • skip-rows (default: 0): number of rows to skip at the beginning of the file (apart from the header and pre-header ones if rows is dict).
  • skip-empty-rows (default: True): whether to omit empty rows (i.e., those with no values) from the result.