Import Data - "xlsx"

I Ain't Afraid of No Code!

[
    [
        "xlsx",
        {
            "read_only": true,
            "include_sheet_name": false,
            "data_only": true,
            "guess_types": false,
            "ignore_missing_sheet": false,
            "include_all_sheets": false,
            "keep_links": true,
            "force_fix": false,
            "subtable": null,
            "keep_vba": false,
            "global_meta_ranges": [
                {
                    "ranges": "I36:I41",
                    "sheet": "Cover"
                }
            ],
            "sheets": [
                {
                    "row_offset": 1,
                    "column_offset": 1,
                    "meta_ranges": "A2:F9",
                    "sheet": "General Info",
                    "range_string": "A1:Z2000"
                }
            ],
            "meta_mapping": {
                "key0": "client_name"
            },
            "meta_target": "general",
            "_comment": null
        }
    ]
]

param boolean read_only: Don’t try to convert data types (Massive impact on performance and memory consumption).

param boolean include_sheet_name: Adding a column with the corresponding sheet names.

param boolean data_only: Don’t try to parse formulas.

param boolean guess_types: Set to true when types should be converted.

param boolean ignore_missing_sheet: Sheets that are listed but not available in a file will be ignored.

param boolean include_all_sheets: Set to true if all sheets should be parsed from the source file.

param boolean keep_links: Whether links to external workbooks should be preserved.

param boolean force_fix: Headers in all sheets will be stripped from leading and trailing white-space characters.

param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).

param boolean keep_vba: Retain Visual Basic code for macros.

param list global_meta_ranges: Read metadata from given sheets and make it available globally.

param list meta_ranges: Read metadata from source file and store it in table configured using meta_target configuration option.

param list sheets: Sheets to be parsed. Multiple sheets will be concatenated ignoring individual headers.

param list subtable_sheets: Sheets to be parsed into subtables. Accessible by name.

param int row_offset: Amount of rows to be skipped.

param int column_offset: Amount of columns to be skipped.

param str range_string: Range in sheet to be considered by parser.

param dict meta_mapping: Maps meta fields to new names. 

param str meta_target: Node under custom_meta_information where metadata should be saved. Required for (global_)meta_ranges.

param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).

param str comment: A comment that will appear in the Transformation UI.

param boolean fix_headers: