LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-05-2008, 07:01 AM   #1
matiasar
Member
 
Registered: Nov 2006
Location: Argentina
Distribution: Debian
Posts: 321
Blog Entries: 1

Rep: Reputation: 31
gnumeric - ssconvert from cli parameters


Hello!
I need to convert an xls file to text file, from console (cli) because I'm trying to automate a process.
Well, I've taken a look to xls2csv and ssconvert, this lastone comes with gnumeric.
Really ssconvert fits my needs because it is able to keep the original format of each spreadsheet cell.

My problem is:

I need to use the text exporter which is configurable as man page said. But I can't find documentation on how to configure the exporter parameters. By gnumeric GUI I know they are parameters like: end of line, separator, quote, format (auto, preserve). I tried using gui and it was able to export to txt in the format I want. So I like to do the same from cli with ssconvert...

I tried ssconvert as follows:

ssconvert -E Gnumeric_stf:stf_assistant myFile.xls myFile.txt

But I need to change some parameters, at least separator and format.

Does anybody knows where how to pass those parameters or where to find info?

Thanks in advance,
Matías
 
Old 11-12-2008, 04:46 AM   #2
matiasar
Member
 
Registered: Nov 2006
Location: Argentina
Distribution: Debian
Posts: 321

Original Poster
Blog Entries: 1

Rep: Reputation: 31
Well, after sending an e-mail to gnumeric mail list I got the answer:

ssconvert -O 'eol=unix separator=; format=preserve charset=UTF-8 locale=es_AR transliterate-mode=transliterate quoting-mode=never' spreadsheet.xls myText.txt

This options worked for my needs.
Fortunatly Gnumeric developers will complete the man page soon.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving CLI data in the CLI Tons of Fun Linux - General 4 04-03-2007 05:42 AM
gnumeric gone from RH? molivera Red Hat 1 10-20-2004 10:26 AM
Gnumeric phishman3579 Slackware 3 06-02-2003 06:06 PM
gnumeric griv Linux - Software 0 06-30-2002 12:56 PM
gnumeric ry Linux - Software 1 06-30-2002 12:27 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:16 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration