xlsx-words-batch
Extract records from MS excel file. Input record must include file_path field (file store url). Output field names are Excel column letters such as A, B, C, and AA. Offset and limit apply per input file. Input record fields are preserved in output records.
xlsx-words-batch [skip=VALUE] [offset=VALUE] [limit=VALUE] [sheet=VALUE]
- skip=VALUE
- Optional. Leading row count to skip per sheet. 0 by default.
- offset=VALUE
- Optional. Skip count of data records, applied per input file
- limit=VALUE
- Optional. Max count of records, applied per input file
- sheet=VALUE
- Optional. Sheet name to read. All sheets by default.
Output Fields
| Field | Type | Name | Description |
|---|---|---|---|
| _sheet | String | Sheet name | Sheet the record belongs to |
| _file | String | File name | Source file name |
| A, B, C, ... | Any | Cell value | Cell values keyed by Excel column letter |
| _error | String | Error message | Set instead of failing the query when a file cannot be read |