Sand_Box

Here are illustrations of the operation of csv2odf. The wiki may not look exactly like a document, but maybe you will get the idea of what the various options do.

• Basic Operation
  • Input data.csv
  • Template template.odt
  • Output output.odt
  • Command
• Examples with options

Basic Operation

Input data.csv

2011-06-14, "Sweep floor", 30
2011-06-15, "Count beans", 60
2011-07-10, "Pickup chips", 45

Template template.odt

Micro Management Report

Date Task Minutes

2000-01-01
Dummy
0

Output output.odt

Micro Management Report

Date Task Minutes

2011-06-14
Sweep floor
30

2011-06-15
Count beans
60

2011-07-10
Pickup chips
45

Command

csv2odf data.csv template.odt output.odt

Examples with options

Click on the option you are interested in to see an example.

-h : displays help information
-v : verbose mode
-H : insert the first csv row into the header
-c <char> : use char as delimiter instead of comma
--comment=<text> : replace [csv2odf-comment] within the document with <text>
-o <spec> : specify column order: 2,1,3 = second csv column is first. Also use to leave the contents of a template column: 1,2,,3,4 = the 3rd template column is not overwritten. Useful if a column contains a formula. The formula cell references will be offset to the correct row.
-s <n> : start reading at the nth row of the csv file
-e <n> : end reading at the nth row of the csv file
-S <n> : skip the first n rows of the template file, the header will be the next row after those skipped
-t <n> : specify which tab or table to add data to, default first table
-d <fmt> : date format within csv data is specified by fmt string, see -D for codes
-D : show a list of date format codes
-q : suppress all warning messages
-x : create an xml output file instead of odf
-n : do not merge the data into output, use with -x to extract test a long line template xml codes
--input=<file> : specify the csv data file location
--template=<file> : specify the tempate file location
--output=<file> : specify the output file location
-V : display version number
-z : display debugging information

[Es:Sand_Box] [:es:Sand_Box]