1SSCONVERT(1) GNOME SSCONVERT(1)
2
6 ssconvert - a command line spreadsheet format converter
7
10 ssconvert [OPTIONS] infile outfile
11 ssconvert [OPTIONS] --merge-to outfile infile1 infile2 ...
13
16 ssconvert is a command line utility to convert spreadsheet files
17 between various spreadsheet file formats. It is a companion utility to
18 Gnumeric, the powerful spreadsheet program created by the GNOME
19 project.
20 ssconvert accepts either file names or URIs as infile outfile. The spe‐
22 cial URIs fd://0 and fd://1 can be used for standard input and standard
23 output respectively.
24
27 This program follows the usual GNU command line syntax, with single
28 letter options starting with a single dash (`-') and longer options
29 starting with two dashes (`--').
30 Main options
33 --recalc
34 Recalculate all cells before writing the result.
35 --list-exporters
37 List the available exporters (file formats that can be written).
38 -T, --export-type=ID
40 Specify which exporter to use; see below for a list. This is
41 only necessary when the right format does not follow from the
42 output file name.
43 -O, --export-options=optionsstring
45 Specify parameters for the chosen exporter. optionsstring is a
46 list of parameter=value pairs, separated by spaces. The parame‐
47 ter names and values allowed are specific to the exporter and
48 are documented below. Multiple parameters can be specified
49 --list-importers
51 List the available importers (file formats that can be read).
52 -I, --import-type=ID Specify which importer to use; see below
53 for a list. This is only necessary when the right format does
54 not follow from the input file name.
55 -E, --import-encoding=STRING
57 Specify an encoding for imported content.
58 -M, --merge-to=FILENAME
60 Merge a collection of workbooks into one. Sheet size will
61 expand to the largest in all the workbooks. Names in the scope
62 of individual workbooks will end up in the scope of the merged
63 workbook. The merge will be aborted if there are name con‐
64 flicts.
65 -S, --export-file-per-sheet
67 Export a file for each sheet if the exporter only supports one
68 sheet at a time. The output filename is treated as a template
69 in which sheet number is substituted for %n and/or sheet name is
70 substituted for %s. If there are not substitutions, a default
71 of ".%s" is added.
72 Help options
75 -v, --version
76 Display ssconvert's version.
77 -h, --help, --usage
79 Display a brief usage message.
80 --help-all
82 Show all help options.
83 --help-libspreadsheet
85 Show Gnumeric options.
86 Path options
89 -L, --lib-dir=STRING
90 Set the root library directory.
91 -D, --data-dir=STRING
93 Adjust the root data directory.
94
97 The following IDs can be can be used both for import (reading) and
98 export (writing).
99 Gnumeric_XmlIO:sax
101 Gnumeric's XML file format (*.gnumeric)
102 Gnumeric_OpenCalc:openoffice
104 OpenDocument ⟨http://en.wikipedia.org/wiki/OpenDocument⟩ or
105 OpenOffice Calc ⟨http://en.wikipedia.org/wiki/
106 OpenOffice.org_Calc⟩ (*.sxc, *.ods) format. As an exporter,
107 this is ODF/OpenOffice without foreign elements (*.ods).
108 Gnumeric_dif:dif
110 Data Interchange Format ⟨http://en.wikipedia.org/wiki/
111 Data_Interchange_Format⟩ (*.dif)
112 Gnumeric_paradox:paradox
114 Paradox database ⟨http://en.wikipedia.org/wiki/
115 Paradox_%28database%29⟩ or primary index file (*.db, *.px)
116 Gnumeric_stf:stf_assistant
118 Text (configurable)
119 Gnumeric_sylk:sylk
121 MultiPlan ⟨http://en.wikipedia.org/wiki/Multiplan⟩ Symbolic Link
122 (SYLK) ⟨http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29⟩
123 (*.slk)
124 Gnumeric_Excel:xlsx
126 Microsoft Excel (tm) 2007 ("Office Open XML", OOXML ⟨http://
127 en.wikipedia.org/wiki/XLSX⟩ ) format
128
131 Gnumeric_stf:stf_csvtab
132 Comma or tab separated values (CSV/TSV) (*.csv)
133 Gnumeric_html:html
135 HTML (*.html, *.htm)
136 Gnumeric_Excel:excel
138 Microsoft Excel (tm) (*.xls)
139 Gnumeric_Excel:excel_xml
141 Microsoft Excel (tm) 2003 SpreadsheetML
142
145 Gnumeric_QPro:qpro
146 Quattro Pro ⟨http://en.wikipedia.org/wiki/Quattro_Pro⟩ (*.wb1,
147 *.wb2, *.wb3)
148 Gnumeric_applix:applix
150 Applix (*.as)
151 Gnumeric_lotus:lotus
153 Lotus 1-2-3 ⟨http://en.wikipedia.org/wiki/Lotus_1-2-3⟩ (*.wk1,
154 *.wks, *.123)
155 Gnumeric_mps:mps
157 MPS (Mathematical Programming System) format ⟨http://
158 en.wikipedia.org/wiki/MPS_%28format%29⟩ Linear programming and
159 mixed integer programming file format (*.mps)
160 Gnumeric_oleo:oleo
162 GNU Oleo ⟨http://en.wikipedia.org/wiki/GNU_Oleo⟩ (*.oleo)
163 Gnumeric_plan_perfect:pln
165 PlanPerfect Format (PLN)
166 Gnumeric_psiconv:psiconv
168 Psion (*.psisheet)
169 Gnumeric_sc:sc
171 SC/xspread
172 Gnumeric_xbase:xbase
174 xBase ⟨http://en.wikipedia.org/wiki/XBase⟩ (*.dbf) file format
175
178 Gnumeric_OpenCalc:odf
179 ODF/OpenOffice with foreign elements (*.ods)
180 Gnumeric_glpk:glpk
182 GLPK Linear Program Solver
183 Gnumeric_html:html40
185 HTML 4.0 (*.html)
186 Gnumeric_html:html40frag
188 HTML (*.html) fragment
189 Gnumeric_html:xhtml
191 XHTML (*.html)
192 Gnumeric_html:xhtml_range
194 XHTML range - for export to clipboard
195 Gnumeric_pdf:pdf_assistant
197 Portable Document Format (*.PDF)
198 Gnumeric_stf:stf_csv
200 Comma separated values (CSV)
201 Gnumeric_Excel:excel_dsf
203 Microsoft Excel (tm) 97/2000/XP & 5.0/95
204
207 Gnumeric_Excel:excel_biff7
208 Microsoft Excel (tm) 5.0/95
209 Gnumeric_Excel:excel_biff8
211 Microsoft S Excel (tm) 97/2000/XP
212 Gnumeric_GnomeGlossary:po
214 Gnome Glossary PO file format
215 Gnumeric_html:html32
217 HTML 3.2 (*.html)
218 Gnumeric_html:latex
220 LaTeX 2e (*.tex)
221 Gnumeric_html:latex_table
223 LaTeX 2e (*.tex) table fragment
224 Gnumeric_html:roff
226 TROFF ⟨http://en.wikipedia.org/wiki/Troff⟩ (*.me) format.
227 Gnumeric_lpsolve:lpsolve
229 LPSolve ⟨http://sourceforge.net/projects/lpsolve/⟩ Mixed Integer
230 Linear Programming (MILP) solver
231
234 sheet Name of the workbook sheet to operate on.
235 paper Paper size. Valid values include "A4" for ISO A4 and "na_let‐
238 ter_8.5x11in" for US Letter.
239
242 sheet Name of the workbook sheet to operate on.
243 eol End Of Line convention; how lines are terminated. "unix" for
246 linefeed, "mac" for carriage return; "windows" for carriage
247 return plus linefeed.
248 charset
251 The character encoding of the output. Defaults to UTF-8.
252 locale The locale to use for number and date formatting. Defaults to
255 the current locale as reported by locale(1). Consult locale -a
256 output for acceptable values.
257 quote The character or string used for quoting fields. Defaults to
260 "\"" (quotation mark / double quote).
261 separator
264 The string used to separate fields. Defaults to space.
265 format How cells should be formatted. Acceptable values: "automatic"
268 (apply automatic formatting; default), "raw" (output data raw,
269 unformatted), or "preserve" (preserve the formatting from the
270 source document).
271 This deals with the difference between a cell's contents and the
273 way those contents are formatted.
274 Consider a cell in a Gnumeric input document that was input as
276 "4/19/73" in a US locale, with a format set to "d-mmm-yyyy" and
277 thus formatted as "19-Apr-1973".
278 With the default format setting of "automatic" it will be output
280 as "1973/04/19". With "preserve", the formatting will be pre‐
281 served and it will be output as "19-Apr-1973". With "raw" it
282 will be output as "26773" (Gnumeric's internal representation:
283 days since an epoch).
284 transliterate-mode
287 How to handle unrepresentable characters (characters that cannot
288 be represented in the chosen output character set). Acceptable
289 values: "transliterate", or "escape".
290 quoting-mode
293 When does data need to be quoted? "never", "auto" (puts quotes
294 where needed), or "always". Defaults to "never".
295 quoting-on-whitespace
298 Controls whether initial or terminal whitespace forces quoting.
299 Defaults to TRUE.
300
304 To convert the Gnumeric file foo.gnumeric to a Microsoft Excel(TM) for‐
305 mat file foo.xls:
306 ssconvert foo.gnumeric foo.xls
308 The export format can be specified explicitly, to override the default
310 (which is based on the file extension):
311 ssconvert --export-type=Gnumeric_stf:stf_csv foo.xls foo.txt
313 To convert an Excel format file statfuns.xls to a text file, specifying
315 the semicolon as the separator character:
316 ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls stat‐
318 funs.txt
319
321 ssconvert is licensed under the terms of the General Public License
322 (GPL), version 2. For information on this license look at the source
323 code that came with the software or see the GNU project page ⟨http://
324 www.gnu.org⟩.
325
328 The copyright on the Gnumeric software and source code is held by the
329 individual authors as is documented in the source code.
330
333 ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert
334 builds on the Gnumeric codebase.
335 The initial version of this manpage was written by J.H.M. Dassen (Ray)
337 <jdassen@debian.org>.
338
341 gnumeric(1), ssgrep(1), ssindex(1)
342 The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.
344 The GNOME project page ⟨http://www.gnome.org/⟩.
346gnumeric 2010-09-14 SSCONVERT(1)