EVL – ETL Tool

Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

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 ’Results:;=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: