table of contents
WKS2CSV(1) | User Commands | WKS2CSV(1) |
NAME¶
wks2csv - manual page for wks2csv 0.4.7
SYNOPSIS¶
wks2csv [OPTION] FILE
DESCRIPTION¶
`wks2csv' converts various spreadsheets and database formats to CSV. Supported formats are Microsoft Works Spreadsheet and Database, Lotus Wk1-Wk4 and Quattro Pro Wq1-Wq2.
OPTIONS¶
- -h
- show this help message
- -d CHAR
- set the decimal commas to character CHAR: default .
- -e ENCODING
- Define the file encoding where encoding can be
- CP037, CP424, CP437, CP737, CP500, CP775, CP850, CP852, CP855, CP856, CP857, CP860, CP861, CP862, CP863, CP864, CP865, CP866, CP869, CP874, CP875, CP932, CP950, CP1006, CP1026, CP1250, CP1251, CP1252, CP1253, CP1254, CP1255, CP1256, CP1257, CP1258, MacArabic, MacCeltic, MacCEurope, MacCroation, MacCyrillic, MacDevanage, MacFarsi, MacGaelic, MacGreek, MacGujarati, MacGurmukhi, MacHebrew, MacIceland, MacInuit, MacRoman, MacRomanian, MacThai, MacTurkish.
- -f CHAR
- Sets the field separator to character CHAR: default ,
- -t CHAR
- set the text separator to character CHAR: default "
- -o FILE
- set the ouput file
- -p PASSWORD
- set password to open the file
- -v
- show version information
- -N
- show the number of sheets
- -n NUM
- choose the sheet to convert (1 means first sheet)
- -F
- set to output the formula which exists in the file
- -D FORMAT
- set date format: default "%m/%d/%y"
- -T FORMAT
- set time format: default "%H:%M:%S"
EXAMPLES¶
- wks2cvs -d, -D"%d/%m/%y" file
- convert a file using french locale
Note:¶
- If -F is present, the formula are generated which english names
REPORTING BUGS¶
Report bugs to <https://sourceforge.net/p/libwps/bugs/> or <https://bugs.documentfoundation.org/>.
April 2018 | libwps 0.4.7 |