xlsx2csv1
Convert xlsx xml files to csv format
Usage
xlsx2csv [options]
INFILE
[OUTPUT
FILE]
Overview
The conversion uses Expat SAX parser for xml processing.
Stdin
Use "-" for INFILE to read from the STDIN.
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 SHEETDELIMITER, --sheetdelimiter=SHEETDELIMITER -
Sheet delimiter used to separate sheets, pass "" if you don't want delimiters. DEfaults to "--------".
-
-q QUOTING, --quoting=QUOTING -
Output csv fields quoting. Use "none" "minimal" "nonnumeric" or "all". Defaults to none.
-
-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.
Releases
6 releases since Debian 8 (Jessie); the text changed 5 times.
--quoting since Debian 10 (Buster);
-q since Debian 10 (Buster).