Stack Overflow
Stack Overflow

Questions tagged [ssconvert]

Use when asking about GNOME project's command line utility for converting the format of spreadsheets.

Usually in conjunction with the tag .

die.net
Ubuntu manuals.
Install ssconvert (part of gnumeric) on a server without GNOME

28 questions
1
vote
1 answer

Convert spreadsheet to .csv on command line without evaluating formulas

I want to convert a spreadsheet (e.g. .xls or from LibreOffice Calc) to some text format, e.g. .csv, without evaluating formulas so the formulas are stored in the text file. I know that LibreOffice has an option "Save cell formula instead of…
user829755
  • 1,489
  • 13
  • 27
1
vote
2 answers

GConf Error: "Failed to contact configuration server ... 1: Not running within active session"

I have installed Gnumeric in CentOS 6.5, then use ssconvert command to convert .xls/.xlsx file to CSV, but I still get the following error: $ ssconvert GConf Error: Failed to contact configuration server; some possible causes are that you…
winds1983
  • 21
  • 5
0
votes
0 answers

ssconvert csv can't handle line breaks in cells

I'm converting an XLSX file to a CSV file with ssconvert inside a script. But I stumbled upon a problem that occurs, when cells contain manual line breaks. Those are kept inside the text as newline-characters, and so the converted csv file is…
rcheetah
  • 37
  • 4
0
votes
0 answers

ssconvert merges column in output

I have problems with the ssconvert. The input is a tab-separated tsv-file that should be converted to xls (not xlsx), but the output combines some on the columns into one long string. Any ideas?
user2300940
  • 2,355
  • 1
  • 22
  • 35
0
votes
0 answers

ssconvert mis-formatting data when converting from csv file to xlsx

I am converting a file from csv file to an xlsx file using the following command /usr/bin/ssconvert --import-type=Gnumeric_stf:stf_csvtab --export-type=Gnumeric_Excel:xlsx --import-encoding=UTF8 sample.csv sample.xlsx The content of sample.csv…
Yirmiyahu Fischer
  • 503
  • 2
  • 9
  • 22
0
votes
1 answer

Converting XLS(X) to csv with ssconvert or something else

I'm trying to convert XLS(X) files to csv on a RHEL server and have learned about gnumeric which includes ssconvert. I've done testing on a lab VM to make sure ssconvert works for what I need. However, I want to know if there is a way to install…
Seth Koberg
  • 965
  • 2
  • 9
  • 15
0
votes
1 answer

Bash script to Batch convert .xlsx files to csv files using ssconvert after SFTP script

The below command works perfectly fine in command line mode find . -maxdepth 1 -name "*.xlsx" -exec ssconvert {} --export-type=Gnumeric_stf:stf_csv \; But while adding the same in a Bash script file after SFTP download code, it isn't executing.…
Alekhya varma
  • 93
  • 2
  • 8
0
votes
2 answers

Using batch script to find filename and run a convert command using that filename

I'm attempting to grab a text file from a folder for conversion to .xls using ssconvert. Currently I have: for /F %%a in ('dir /b *.txt') do set FileName=%%~na ssconvert %FileName%.txt %FileName%.xls However this results in this being…
zib24
  • 149
  • 1
  • 1
  • 6
0
votes
0 answers

Different result of date format in output file

I am creating .txt file from .xlsx file using ssconvert command. But issue is not being able to maintain data format in output .txt file - is appearing something else. Please help me to fix the ssconvert command so that I can get the same date…
as7951
  • 187
  • 3
  • 11
0
votes
0 answers

Multiple tables with different columns on single BIRT reports

I have a BIRT report with multiple tables with different datasets and number of columns on it. I generate output in .xls and convert into .csv using ssconvert utility on Unix. But in the .csv file I see extra delimiter for tables where there are…
Tej
  • 1
0
votes
1 answer

Space delimited with 'ssconvert'

I want to use ssconvert from Gnumeric to convert an Excel file to .txt file. The command should be: ssconvert -O 'separator= ' excel.xlsx result.txt However, it doesn't insert ' ' between cells. For example A B is written as AB. How can I fix…
mahmood
  • 23,197
  • 49
  • 147
  • 242
0
votes
1 answer

How to copy all .xls files from INBOUND folder in Unix

I want to copy all .xls files only from the INBOUND folder to the target folder and convert all .xls files to .csv files. Below is the code I wrote but it is not working…
Midhun CM
  • 81
  • 1
  • 8
0
votes
2 answers

How to execute 'ssconvert' command using subprocess

I want to execute the following command: ssconvert /data/sam.xls,/data/test.csv I have tried: p = subprocess.Popen(["ssconvert", '/data/sam.xls','/data/test.csv'], stdout=subprocess.PIPE,shell=True) out = p.communicate() print"output",…
Abdul Razak
  • 2,654
  • 2
  • 18
  • 24
1
2