Unix/Linux Go Back    


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

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)


SSCONVERT(1)				      GNOME				     SSCONVERT(1)

NAME
       ssconvert - a command line spreadsheet format converter

SYNOPSIS
       ssconvert [OPTIONS] infile outfile

       ssconvert [OPTIONS] --merge-to outfile infile1 infile2 ...

DESCRIPTION
       ssconvert  is  a command line utility to convert spreadsheet files between various spread-
       sheet file formats. It is a companion utility to Gnumeric, the powerful	spreadsheet  pro-
       gram 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.

OPTIONS
       This program follows the usual GNU command line syntax, with single letter options  start-
       ing 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  parame-
	      ter=value  pairs,  separated by spaces.  The parameter names and values allowed are
	      specific to the exporter and are documented below. Multiple parameters can be spec-
	      ified

       --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 con-
	      flicts.

   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.

LIST OF IMPORTANT IDS
       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

LIST OF LESS IMPORTANT IDS
       Gnumeric_sylk:sylk
	      SYmbolic	LinK (SYLK) <http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)> or Multi-
	      plan 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.

EXAMPLES
       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 character:

       ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls statfuns.txt

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

COPYRIGHT
       The  copyright  on the gnumeric software and source code is held by the individual authors
       as is documented in the source code.

AUTHOR
       ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert builds on the gnu-
       meric codebase.

       The   initial   version	 of   this   manpage   was   written   by   J.H.M.  Dassen  (Ray)
       <jdassen@debian.org>.

SEE ALSO
       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)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums


All times are GMT -4. The time now is 07:33 PM.