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 path=VALUE [skip=VALUE] [offset=VALUE] [limit=VALUE] [sheet=VALUE]
- path=VALUE
- Required. Target excel file url, formatted as scheme://profile/path. Wildcard is allowed in the file name.
- 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.
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 |