Scroll to navigation

xlsx2csv(1) User Commands xlsx2csv(1)

NAME

xlsx2csv - Convert xlsx xml files to csv format

SYNOPSIS

  xlsx2csv [options] INFILE [OUTPUT FILE]

DESCRIPTION

The conversion uses Expat SAX parser for xml processing.

OPTIONS

-d DELIMITER, --delimiter=DELIMITER
Output csv columns delimiter. Use "tab" or "x09" for tab. Defaults to comma.
-f DATEFORMAT, --dateformat=DATEFORMAT
Set date/time format. See strftime(3) for %-format specifiers. An example "%Y-%m-%d".
-i, --ignoreempty
Skip empty lines.
-p DATEFORMAT, --sheetdelimiter=SHEETDELIMITER
Sheet delimiter used to separate sheets, pass "" if you don't want delimiters. DEfaults to "--------".
-r, --recursive
Convert recursively.
-s SHEETID, --sheet=SHEETID
Sheet to convert (0 for all sheets).
-h, --help
Display short help and exit.
--version
Display program's version number and exit.

ENVIRONMENT

None.

FILES

None.

SEE ALSO

catdoc(1)

AUTHORS

Program was written by Dilshod Temirkhodjaev <tdilshod@gmail.com>

This manual page was written by Jari Aalto <jari.aalto@cante.net>. Released under license GNU GPL version 2 or (at your option) any later version. For more information about the license, visit <http://www.gnu.org/copyleft/gpl.html>.

2016-10-29 xlsx2csv