Writexlsx
(since EVL 2.1)
Write stdin or <f_in> into <file>.
- Writexlsx
-
is to be used in EVS job structure definition file.
<f_in>is either input file or flow name. - evl writexlsx
-
is intended for standalone usage, i.e. to be invoked from command line and reading records from standard input.
EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).
Header and footer format:
All possible self-explained formats:
font:bold font:italic underline:single underline:double align:left align:center align:right color:black color:blue color:brown color:cyan color:gray color:green color:lime color:magenta color:navy color:orange color:pink color:purple color:red color:silver color:white color:yellow bg-color:black bg-color:blue bg-color:brown bg-color:cyan bg-color:gray bg-color:green bg-color:lime bg-color:magenta bg-color:navy bg-color:orange bg-color:pink bg-color:purple bg-color:red bg-color:silver bg-color:white bg-color:yellow
Synopsis
Writexlsx <f_in> <file> (<evd>|-d <inline_evd>) [-h|--header [<header_fields>] [--header-format]] [-f|--footer <footer_fields> [--footer-format]] [-x|--text-input] evl writexlsx <file> (<evd>|-d <inline_evd>) [-h|--header [<header_fields>] [--header-format]] [-f|--footer <footer_fields> [--footer-format]] [-x|--text-input] [-v|--verbose] evl writexlsx ( --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’ - -f, --footer=<footer_fields>
-
semicolon separated list of footer cells, it can be a string or if it begins with ‘=’ sign it is a formula. Variable ‘$COLUMN_RANGE’ can be used in such formulas which will be replaced by range of given column. Example: –footer ’Reults:;=SUM($COLUMN_RANGE);AVERAGE($COLUMN_RANGE)’
- --footer-format=<footer_format>
-
semicolon separated format of the footer. Example: –footer-format "font:bold;bg-color:green;color:white"
- -h, --header=<header_fields>
-
semicolon separated list of header captions, empty
<header_fields>means to use field names from EVD. Example: –header ’ID;timestamp;price’ - --header-format=<header_format>
-
semicolon separated format of the header. Example: –header-format "font:bold;color:red"
- -x, --text-input
-
suppose the input 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