xlsx2csv

Type:command
Package:prepDATA/1.1 — Conversion, Transformation and Plotting of Basic Data Files
Namespace:&type1

Description

xlsx to csv converter.

Usage

xlsx2csv {options}
Bash equivalent: xlsx2csv {options}
usage: xlsx2csv [-h] [-v] [-a] [-c OUTPUTENCODING] [-d DELIMITER]
[–hyperlinks] [-e]
[-E EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN …]]
[-f DATEFORMAT] [-t TIMEFORMAT] [–floatformat FLOATFORMAT]
[–sci-float]
[-I INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN …]]
[–ignore-formats IGNORE_FORMATS [IGNORE_FORMATS …]]
[-l LINETERMINATOR] [-m] [-n SHEETNAME] [-i]
[–skipemptycolumns] [-p SHEETDELIMITER] [-q QUOTING]
[-s SHEETID]
xlsxfile [outfile]
.
xlsx to csv converter
.
positional arguments:
xlsxfile xlsx file path
outfile output csv file path
.
optional arguments:
-h, –help show this help message and exit
-v, –version show program’s version number and exit
-a, –all export all sheets
-c OUTPUTENCODING, –outputencoding OUTPUTENCODING
encoding of output csv ** Python 3 only ** (default:
utf-8)
-d DELIMITER, –delimiter DELIMITER
delimiter - columns delimiter in csv, ‘tab’ or ‘x09’
for a tab (default: comma ‘,’)
–hyperlinks, –hyperlinks
include hyperlinks
-e, –escape Escape
characters
-E EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN …], –exclude_sheet_pattern EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN …]
exclude sheets named matching given pattern, only
effects when -a option is enabled.
-f DATEFORMAT, –dateformat DATEFORMAT
override date/time format (ex. %Y/%m/%d)
-t TIMEFORMAT, –timeformat TIMEFORMAT
override time format (ex. %H/%M/%S)
–floatformat FLOATFORMAT
override float format (ex. %.15f)
–sci-float force scientific notation to float
-I INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN …], –include_sheet_pattern INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN …]
only include sheets named matching given pattern, only
effects when -a option is enabled.
–ignore-formats IGNORE_FORMATS [IGNORE_FORMATS …]
Ignores format for specific data types.
-l LINETERMINATOR, –lineterminator LINETERMINATOR
line terminator - lines terminator in csv, ‘
‘ ‘
‘
or ‘
‘ (default:
)
-m, –merge-cells merge cells
-n SHEETNAME, –sheetname SHEETNAME
sheet name to convert
-i, –ignoreempty skip empty lines
–skipemptycolumns skip trailing empty columns
-p SHEETDELIMITER, –sheetdelimiter SHEETDELIMITER
sheet delimiter used to separate sheets, pass ‘’ if
you do not need delimiter, or ‘x07’ or ‘ ‘ for form
feed (default: ‘——–’)
-q QUOTING, –quoting QUOTING
quoting - fields quoting in csv, ‘none’ ‘minimal’
‘nonnumeric’ or ‘all’ (default: minimal)
-s SHEETID, –sheet SHEETID
sheet number to convert