1CSV2ODS(1)                       User commands                      CSV2ODS(1)
2
3
4

NAME

6       csv2ods - Create OpenDocument spreadsheet from comma separated values
7

SYNOPSIS

9       csv2ods -i file.csv -o file.ods
10

DESCRIPTION

12       This program reads a file in CSV format - table of columns delimited by
13       commas, tabs or any other character. It then creates a spreadsheet. If
14       a value looks like a number the cell is formatted as a number as well.
15

OPTIONS

17       --version
18           Show programĀ“s version number and exit
19
20       -h, --help
21           Show help message and exit
22
23       -i INPUT, --input=INPUT
24           File input in csv.
25
26       -o OUTPUT, --output=OUTPUT
27           File output in ods.
28
29       -d DELIMITER, --delimiter=DELIMITER
30           Specifies a one-character string to use as the field separator. It
31           defaults to ",".
32
33       -c ENCODING, --encoding=ENCODING
34           Specifies the encoding the file csv. It defaults to utf-8.
35
36       -t TABLENAME, --table=TABLENAME
37           The table name in the output file.
38
39       -s SKIPINITIALSPACE, --skipinitialspace=SKIPINITIALSPACE
40           Specifies how to interpret whitespace which immediately follows a
41           delimiter. It defaults to False, which means that whitespace
42           immediately following a delimiter is part of the following field.
43
44       -l LINETERMINATOR, --lineterminator=LINETERMINATOR
45           Specifies the character sequence which should terminate rows.
46
47       -q QUOTING, --quoting=QUOTING
48           It can take on any of the following module constants: 0 =
49           QUOTE_MINIMAL means only when required, for example, when a field
50           contains either the quotechar or the delimiter. 1 = QUOTE_ALL means
51           that quotes are always placed around fields. 2 = QUOTE_NONNUMERIC
52           means that quotes are always placed around fields which do not
53           parse as integers or floating point numbers. 3 = QUOTE_NONE means
54           that quotes are never placed around fields. It defaults is
55           QUOTE_MINIMAL.
56
57       -e ESCAPECHAR, --escapechar=ESCAPECHAR
58           Specifies a one-character string used to escape the delimiter when
59           quoting is set to QUOTE_NONE.
60
61       -r QUOTECHAR, --quotechar=QUOTECHAR
62           Specifies a one-character string to use as the quoting character.
63           It defaults to ".
64

EXAMPLE

66           csv2ods -i /etc/passwd -o accounts.odt -d:
67

AUTHOR

69       Agustin Henze <agustinhenze at gmail.com>
70           Original author of csv-ods.py
71
72
73
74odfpy                             01/04/2009                        CSV2ODS(1)
Impressum