1WKS2CSV(1)                       User Commands                      WKS2CSV(1)
2
3
4

NAME

6       wks2csv - manual page for wks2csv 0.4.12
7

SYNOPSIS

9       wks2csv [OPTION] FILE
10

DESCRIPTION

12       `wks2csv'  converts  various  spreadsheets and database formats to CSV.
13       Supported formats are Microsoft Works Spreadsheet and  Database,  Lotus
14       Wk1-Wk4 and Quattro Pro Wq1-Wq2.
15

OPTIONS

17       -h     show this help message
18
19       -d CHAR
20              set the decimal commas to character CHAR: default .
21
22       -e ENCODING
23              Define the file encoding where encoding can be
24
25              CP037,  CP424,  CP437, CP737, CP500, CP775, CP850, CP852, CP855,
26              CP856, CP857, CP860, CP861, CP862, CP863, CP864,  CP865,  CP866,
27              CP869,  CP874,  CP875,  CP932,  CP950,  CP1006,  CP1026, CP1250,
28              CP1251, CP1252, CP1253, CP1254, CP1255, CP1256, CP1257,  CP1258,
29              MacArabic,   MacCeltic,  MacCEurope,  MacCroation,  MacCyrillic,
30              MacDevanage, MacFarsi, MacGaelic, MacGreek, MacGujarati, MacGur‐
31              mukhi,  MacHebrew,  MacIceland, MacInuit, MacRoman, MacRomanian,
32              MacThai, MacTurkish.
33
34       -f CHAR
35              Sets the field separator to character CHAR: default ,
36
37       -t CHAR
38              set the text separator to character CHAR: default "
39
40       -o FILE
41              set the ouput file
42
43       -p PASSWORD
44              set password to open the file
45
46       -v     show version information
47
48       -N     show the number of sheets
49
50       -n NUM choose the sheet to convert (1 means first sheet)
51
52       -F     set to output the formula which exists in the file
53
54       -D FORMAT
55              set date format: default "%m/%d/%y"
56
57       -T FORMAT
58              set time format: default "%H:%M:%S"
59

EXAMPLES

61       wks2cvs -d, -D"%d/%m/%y" file
62              convert a file using french locale
63
64   Note:
65              If -F is present, the formula are generated which english names
66

REPORTING BUGS

68       Report    bugs    to    <https://sourceforge.net/p/libwps/bugs/>     or
69       <https://bugs.documentfoundation.org/>.
70
71
72
73libwps 0.4.12                    January 2022                       WKS2CSV(1)
Impressum