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 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.
OPTIONS
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, separated by spaces. The
parameter names and values allowed are specific to the exporter
and are documented 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.
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 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.
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 gnumeric 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/>.