Home Man
Today's Posts

Linux & Unix Commands - Search Man Pages

SuSE 11.3 - man page for ssconvert (suse section 1)


ssconvert - a command line spreadsheet format converter
ssconvert [OPTIONS] infile outfile ssconvert [OPTIONS] --merge-to outfile infile1 infile2 ...
ssconvert is a command line utility to convert spreadsheet files between various spreadsheet file formats. It is a companion utility to Gnumeric, the powerful spreadsheet program created by the GNOME project. ssconvert accepts either file names or URIs as infile outfile. The special URIs fd://0 and fd://1 can be used for standard input and standard output respectively.
This program follows the usual GNU command line syntax, with single letter options starting with a single dash (`-') and longer options starting with two dashes (`--'). Main options --recalc Recalculate all formulas before writing. --list-exporters List the available exporters (file formats). -T, --export-type=ID Specify which exporter to use; see below for a list. This is only necessary when the right format does not follow from the output file name. -O, --export-options=optionsstring Specify parameters for the chosen exporter. optionsstring is a list of parameter=value pairs, sepa- rated by spaces. The parameter names and values allowed are specific to the exporter and are docu- mented below. Multiple parameters can be specified --list-importers List the available importers (file formats). -T, --import-type=ID Specify which importer to use; see below for a list. This is only necessary when the right format does not follow from the input file name. -E, --import-encoding=STRING Specify an encoding for imported content. -M, --merge-to=FILENAME Merge a collection of workbooks into one. Sheet size will expand to the largest in all the workbooks. Names in the scope of individual workbooks will end up in the scope of the merged workbook. The merge will be aborted if there are name conflicts. Help options -v, --version Display ssconvert's version. -h, --help, --usage Display a brief usage message. Path options -L, --lib-dir=STRING Set the root library directory. -D, --data-dir=STRING Adjust the root data directory.
Gnumeric_XmlIO:sax Gnumeric's XML file format Gnumeric_Excel:excel_dsf Microsoft Excel (tm) 97/2000/XP & 5.0/95 format Gnumeric_Excel:xlsx Microsoft Excel (tm) 2007 ("Office Open XML", OOXML <http://en.wikipedia.org/wiki/XLSX> ) format Gnumeric_pdf:pdf_assistant Portable Document Format Gnumeric_stf:stf_assistant Text export (configurable) (*.txt) Gnumeric_stf:stf_csv Comma Separated Values
Gnumeric_sylk:sylk SYmbolic LinK (SYLK) <http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)> or Multiplan format Gnumeric_Excel:excel_biff8 Microsoft Excel (tm) 97/2000/XP format Gnumeric_Excel:excel_biff7 Microsoft Excel (tm) 5.0/95 format Gnumeric_dif:dif Data Interchange Format <http://en.wikipedia.org/wiki/Data_Interchange_Format> (*.dif) Gnumeric_html:roff TROFF <http://en.wikipedia.org/wiki/Troff> (*.me) format. Gnumeric_html:latex_table LaTeX 2e (*.tex) table fragment Gnumeric_html:latex LaTeX 2e (*.tex) Gnumeric_html:xhtml_range XHTML range - for export to clipboard Gnumeric_html:xhtml XHTML (*.html) Gnumeric_html:html40frag HTML (*.html) fragment Gnumeric_html:html40 HTML 4.0 (*.html) Gnumeric_html:html32 HTML 3.2 (*.html) Gnumeric_OpenCalc:openoffice OpenDocument <http://en.wikipedia.org/wiki/OpenDocument> or OpenOffice Calc <http://en.wikipedia.org/ wiki/OpenOffice.org_Calc> (*.ods) format Gnumeric_paradox:paradox Paradox database <http://en.wikipedia.org/wiki/Paradox_(database)> (*.db) format OPTIONS FOR THE PORTABLE DOCUMENT FORMAT (*.pdf) EXPORTER sheet Name of the workbook sheet to operate on. paper Paper size. Valid values include "A4" for ISO A4 and "na_letter_8.5x11in" for US Letter. OPTIONS FOR THE CONFIGURABLE TEXT (*.txt) EXPORTER sheet Name of the workbook sheet to operate on. eol End Of Line convention; how lines are terminated. "unix" for linefeed, "mac" for carriage return; "windows" for carriage return plus linefeed. charset The character encoding of the output. Defaults to UTF-8. locale quote The character or string used for quoting fields. Defaults to "\"" (quotation mark / double quote). separator The string used to separate fields. Defaults to space. format Acceptable values: "automatic", "raw", or "preserve". transliterate-mode How to handle characters that cannot be represented in the chosen output character set. Acceptable values: "transliterate", or "escape". quoting-mode When does data need to be quoted? "never", "auto" (puts quotes where needed), or "always". Defaults to "never". quoting-on-whitespace Controls whether initial or terminal whitespace forces quoting. Defaults to TRUE.
To convert the gnumeric file foo.gnumeric to a Microsoft Excel(TM) format file foo.xls: ssconvert foo.gnumeric foo.xls The export format can be specified explicitly, to override the default (which is based on the file extension): ssconvert --export-type=Gnumeric_stf:stf_csv foo.xls foo.txt To convert an Excel format file statfuns.xls to a text file, specifying the semicolon as the separator charac- ter: ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls statfuns.txt
ssconvert is licensed under the terms of the General Public License (GPL), version 2. For information on this license look at the source code that came with the software or see the GNU project page <http://www.gnu.org>.
The copyright on the gnumeric software and source code is held by the individual authors as is documented in the source code.
ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert builds on the gnumeric codebase. The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.
gnumeric(1), ssgrep(1), ssindex(1) The Gnumeric Homepage <http://www.gnome.org/projects/gnumeric/>. The GNOME project page <http://www.gnome.org/>. gnumeric 2009-02-08 SSCONVERT(1)

All times are GMT -4. The time now is 01:49 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
Show Password