Readxls
(since EVL 2.2)
Read XLS sheet and write to <f_out>
.
Unless ‘--sheet-index’ or ‘--sheet-name’ is specified, it reads only the first sheet from the file.
It skips the header line, unless option ‘--no-header’ or ‘--match-fields’ is used.
- Readxls
-
is to be used in EVS job structure definition file.
<f_out>
is either output file or flow name. - evl readxls
-
is intended for standalone usage, i.e. to be invoked from command line and writing records to standard output.
EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).
Synopsis
Readxls <file> <f_out> (<evd>|-d <inline_evd>) [-m|--match-fields | --no-header] [--sheet-index=<n> | --sheet-name=<name>] [-y|--text-output] evl readxls <file> (<evd>|-d <inline_evd>) [-m|--match-fields | --no-header] [--sheet-index=<n> | --sheet-name=<name>] [-y|--text-output] [-v|--verbose] evl readxls ( --help | --usage | --version )
Options
- -d, --data-definition=<inline_evd>
-
either this option or the file
<evd>
must be presented. Example: ‘-d 'id int, name string, started timestamp'’ - -m, --match-fields
-
read only fields specified by EVD, based on header. All characters other than ‘[a-zA-Z0-9_-]’ are replaced by underscore when matching with EVD field names.
- --no-header
-
suppose there is no header
- --sheet-index=<n>
-
read
<n>
-th sheet, starting from number 0 (i.e. ‘--sheet-index=0’ is the default behaviour) - --sheet-name=<name>
-
read sheet with name
<name>
- -y, --text-output
-
write the output as text, not binary
Standard options:
- --help
-
print this help and exit
- --usage
-
print short usage information and exit
- -v, --verbose
-
print to stderr info/debug messages of the component
- --version
-
print version and exit