Table of Contents

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

Copyright © 2017–2020 EVL Tool, s.r.o.

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.


Read XLSX 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.


is to be used in EVS job structure definition file. <f_out> is either output file or flow name.

evl readxlsx

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).


  <file> <f_out> (<evd>|-d <inline_evd>)
  [-m|--match-fields | --no-header]
  [--sheet-index=<n> | --sheet-name=<name>]

evl readxlsx
  <file> (<evd>|-d <inline_evd>)
  [-m|--match-fields | --no-header]
  [--sheet-index=<n> | --sheet-name=<name>]

evl readxlsx
  ( --help | --usage | --version )


-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.


suppose there is no header


read <n>-th sheet, starting from number 0 (i.e. ‘--sheet-index=0’ is the default behaviour)


read sheet with name <name>

-y, --text-output

write the output as text, not binary

Standard options:


print this help and exit


print short usage information and exit

-v, --verbose

print to stderr info/debug messages of the component


print version and exit