xlsx-words
Extract records from MS excel file. Output field names are Excel column letters such as A, B, C, and AA. Offset and limit carry over across sheets and wildcard-matched files.
xlsx-words url=VALUE [skip=VALUE] [offset=VALUE] [limit=VALUE] [sheet=VALUE] [insecure=VALUE]
- url=VALUE
- Required. Target excel file url, formatted as scheme://profile/path or an http(s) url. Wildcard is allowed in the file name of a file store url.
- skip=VALUE
- Optional. Leading row count to skip per sheet. 0 by default.
- offset=VALUE
- Optional. Skip count of data records
- limit=VALUE
- Optional. Max count of records
- 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 |