xlsx-words-batch
Extract records from MS excel file. Input record must include url field (file store url or http(s) 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] [insecure=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.
- insecure=VALUE
- Optional. t to skip TLS certificate and hostname verification for an https url. Default is f.
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 |