10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have a file with the below contents :
Policy Name: Backup_bkp
Policy Type: Catalog_bkp
Active: yes
Effective date: 08/07/2013 02:02:12
Mult. Data Streams: no
Client Encrypt: no
Checkpoint: no
Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies
2. Shell Programming and Scripting
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies
3. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
4. Shell Programming and Scripting
Hello friends
I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns
1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
6 Replies
5. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
6. Shell Programming and Scripting
I am trying to convert xlsx sheet to a csv file.
In .xlsx file there a cell with date
Mon 08/27/12
while reading this cell using Spreadsheet::XLSX, the output is display with numeric value i.e., 41148.
from Spreadsheet::XLSX module :
use Text::Iconv;
my $converter =... (1 Reply)
Discussion started by: giridhar276
1 Replies
7. Shell Programming and Scripting
Hi ,
I am writing a simple excel file and want to create the file under say 'D:\Documents and Settings'. The problem with my code is it is writing in the same directory instead of the specified. Here is a sample code
use Spreadsheet::WriteExcel;
my $workbook =... (1 Reply)
Discussion started by: daptal
1 Replies
8. Shell Programming and Scripting
Hi,
I would like to modify an existing excel cell format to a custom format.
Is there a way to do it with out writing into a new excel file.
In-place editing?
Thanks (0 Replies)
Discussion started by: sandeep78
0 Replies
9. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
10. Filesystems, Disks and Memory
Hi,
I have a problem in formatting the excel file from my script.
Assume that there is a text file generated using a 'C shell Unix script' with a format similar to the one seen below. Each column has a fixed length and every row is going to have a value against a column depending on the... (1 Reply)
Discussion started by: subra
1 Replies
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 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 stan-
dard 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 cells before writing the result.
--list-exporters
List the available exporters (file formats that can be written).
-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 that can be read). -I, --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 indi-
vidual workbooks will end up in the scope of the merged workbook. The merge will be aborted if there are name conflicts.
-S, --export-file-per-sheet
Export a file for each sheet if the exporter only supports one sheet at a time. The output filename is treated as a template in
which sheet number is substituted for %n and/or sheet name is substituted for %s. If there are not substitutions, a default of
".%s" is added.
Help options
-v, --version
Display ssconvert's version.
-h, --help, --usage
Display a brief usage message.
--help-all
Show all help options.
--help-libspreadsheet
Show Gnumeric options.
Path options
-L, --lib-dir=STRING
Set the root library directory.
-D, --data-dir=STRING
Adjust the root data directory.
LIST OF IMPORTER
/EXPORTER IDS
The following IDs can be can be used both for import (reading) and export (writing).
Gnumeric_XmlIO:sax
Gnumeric's XML file format (*.gnumeric)
Gnumeric_OpenCalc:openoffice
OpenDocument <http://en.wikipedia.org/wiki/OpenDocument> or OpenOffice Calc <http://en.wikipedia.org/wiki/OpenOffice.org_Calc>
(*.sxc, *.ods) format. As an exporter, this is ODF/OpenOffice without foreign elements (*.ods).
Gnumeric_dif:dif
Data Interchange Format <http://en.wikipedia.org/wiki/Data_Interchange_Format> (*.dif)
Gnumeric_paradox:paradox
Paradox database <http://en.wikipedia.org/wiki/Paradox_%28database%29> or primary index file (*.db, *.px)
Gnumeric_stf:stf_assistant
Text (configurable)
Gnumeric_sylk:sylk
MultiPlan <http://en.wikipedia.org/wiki/Multiplan> Symbolic Link (SYLK) <http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29>
(*.slk)
Gnumeric_Excel:xlsx
Microsoft Excel (tm) 2007 ("Office Open XML", OOXML <http://en.wikipedia.org/wiki/XLSX> ) format
LIST OF IMPORTANT IMPORTER IDS
Gnumeric_stf:stf_csvtab
Comma or tab separated values (CSV/TSV) (*.csv)
Gnumeric_html:html
HTML (*.html, *.htm)
Gnumeric_Excel:excel
Microsoft Excel (tm) (*.xls)
Gnumeric_Excel:excel_xml
Microsoft Excel (tm) 2003 SpreadsheetML
LIST OF OTHER IMPORTER IDS
Gnumeric_QPro:qpro
Quattro Pro <http://en.wikipedia.org/wiki/Quattro_Pro> (*.wb1, *.wb2, *.wb3)
Gnumeric_applix:applix
Applix (*.as)
Gnumeric_lotus:lotus
Lotus 1-2-3 <http://en.wikipedia.org/wiki/Lotus_1-2-3> (*.wk1, *.wks, *.123)
Gnumeric_mps:mps
MPS (Mathematical Programming System) format <http://en.wikipedia.org/wiki/MPS_%28format%29> Linear programming and mixed integer
programming file format (*.mps)
Gnumeric_oleo:oleo
GNU Oleo <http://en.wikipedia.org/wiki/GNU_Oleo> (*.oleo)
Gnumeric_plan_perfect:pln
PlanPerfect Format (PLN)
Gnumeric_psiconv:psiconv
Psion (*.psisheet)
Gnumeric_sc:sc
SC/xspread
Gnumeric_xbase:xbase
xBase <http://en.wikipedia.org/wiki/XBase> (*.dbf) file format
LIST OF IMPORTANT EXPORTER IDS
Gnumeric_OpenCalc:odf
ODF/OpenOffice with foreign elements (*.ods)
Gnumeric_glpk:glpk
GLPK Linear Program Solver
Gnumeric_html:html40
HTML 4.0 (*.html)
Gnumeric_html:html40frag
HTML (*.html) fragment
Gnumeric_html:xhtml
XHTML (*.html)
Gnumeric_html:xhtml_range
XHTML range - for export to clipboard
Gnumeric_pdf:pdf_assistant
Portable Document Format (*.PDF)
Gnumeric_stf:stf_csv
Comma separated values (CSV)
Gnumeric_Excel:excel_dsf
Microsoft Excel (tm) 97/2000/XP & 5.0/95
LIST OF OTHER EXPORTER IDS
Gnumeric_Excel:excel_biff7
Microsoft Excel (tm) 5.0/95
Gnumeric_Excel:excel_biff8
Microsoft S Excel (tm) 97/2000/XP
Gnumeric_GnomeGlossary:po
Gnome Glossary PO file format
Gnumeric_html:html32
HTML 3.2 (*.html)
Gnumeric_html:latex
LaTeX 2e (*.tex)
Gnumeric_html:latex_table
LaTeX 2e (*.tex) table fragment
Gnumeric_html:roff
TROFF <http://en.wikipedia.org/wiki/Troff> (*.me) format.
Gnumeric_lpsolve:lpsolve
LPSolve <http://sourceforge.net/projects/lpsolve/> Mixed Integer Linear Programming (MILP) solver
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 The locale to use for number and date formatting. Defaults to the current locale as reported by locale(1). Consult locale -a out-
put for acceptable values.
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 How cells should be formatted. Acceptable values: "automatic" (apply automatic formatting; default), "raw" (output data raw, unfor-
matted), or "preserve" (preserve the formatting from the source document).
This deals with the difference between a cell's contents and the way those contents are formatted.
Consider a cell in a Gnumeric input document that was input as "4/19/73" in a US locale, with a format set to "d-mmm-yyyy" and thus
formatted as "19-Apr-1973".
With the default format setting of "automatic" it will be output as "1973/04/19". With "preserve", the formatting will be preserved
and it will be output as "19-Apr-1973". With "raw" it will be output as "26773" (Gnumeric's internal representation: days since an
epoch).
transliterate-mode
How to handle unrepresentable characters (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.
EXAMPLE
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/>.
gnumeric 2010-09-14 SSCONVERT(1)