Parse an Excel file. Please note that sheets and subtable sheets are processed in the order of given statement. All sheet-specific options can be used for each sheet separately.
Example
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:
Comments
0 comments
Article is closed for comments.