wks2csv - Man Page

manual page for wks2csv 0.4.14

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/>.

Info

January 2024 libwps 0.4.14