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
51
votes
4 answers

batch script - run command on each file in directory

I need to convert some xls files into xlsx files. I can successfully convert one xls file into xlsx by running this command into cmd prompt (windows): ssconvert inputFileName.xls outputFileName.xlsx (ssconvert is a Gnumeric's command-line utility…
BeNdErR
  • 17,471
  • 21
  • 72
  • 103
20
votes
3 answers

How to import .ods?

I'm trying to import data (.ods file) and I know how to import .csv, .xls etc. but I strand all the time. I tried it with the package Gnumeric but R tells me that the required program 'ssconvert' cannot be found.
Thomas
  • 1,392
  • 3
  • 22
  • 38
6
votes
2 answers

Convert CSV to XLS using 'ssconvert' with delimiter

I've got a CSV file with delimiter character being |, but can't really find a way to convert it to XLS that would apply the delimiter. ssconvert -O 'separator=|' test.csv test.xls will obviously yield with message like: The file saver does not…
Patrick
  • 165
  • 1
  • 4
  • 13
4
votes
2 answers

Replace or ignore new line character when converting .ods files to .csv files

I'm using ssconvert in Gnumeric to convert a bunch of ODS files to CSV files with the command: ssconvert -O 'separator=; quoting-mode=never' "f.ods" "f.txt"; which works out great ... most of the time. Sometimes, there are cells where the user has…
Speldosa
  • 1,900
  • 5
  • 21
  • 36
4
votes
2 answers

How to convert .csv to .xls

I have a simple .csv file. Is it possible to convert it to .xls using the command line tool ssconvert? I would also need to specify the name of the sheet.
RockScience
  • 17,932
  • 26
  • 89
  • 125
2
votes
1 answer

Creating TAB-separated values from .xlsx with ssconvert

Due to commas within cell values, I am not able to use the ssconvert utility for .xls(x) to .csv conversion. Is there a possibility to create tab-separated values directly from xlsx with ssconvert (command line spreadsheet format converter)?…
corinna
  • 629
  • 7
  • 18
2
votes
1 answer

How to convert .xls to .csv in Unix

I have a text file (abc.txt) which will be having the file name along with the path which is to be converted to .csv. Below is the script I wrote: {while IFS= read -r f ; do filename="${f%.*}" ssconvert ${filename}.xls ${filename}.csv done <…
Midhun
  • 331
  • 2
  • 5
  • 15
2
votes
0 answers

How do I get 'ssconvert' to embed off-sheet references?

I have this working, using Gnumeric's ssconvert: ssconvert --merge-to=merged.xls test1.csv test2.csv test3.csv It happily imports formulae, such as =MIN(G2:G4) correctly. The problem I have is with off-sheet references. How do I, with the above…
Peter Brooks
  • 349
  • 3
  • 13
2
votes
1 answer

How to prevent `ssconvert` recalculating Excel file before conversion?

I am trying to convert the .xlsx file http://www.eia.gov/forecasts/steo/archives/mar14_base.xlsx into a .csv, but it seems that the .xlsx contains formulae that link to a local file that I don't have (the creator of the file must have forgotten to…
RockScience
  • 17,932
  • 26
  • 89
  • 125
1
vote
0 answers

How to keep date format when converting CSV to XLSX with SSCONVERT

I am trying to convert a simple csv file that contains a date format as d.m.Y to an excel file using ssconvert but ssconvert changes the date format to d/m/Y The command below without option on the format is changing the date format of the xlsx…
Dominick Makome
  • 11
  • 2
1
vote
0 answers

ssconvert - How to specify a specific field format

I'm looking for the way to specify a field format when converting an .xlsx file to csv using ssconvert tool on linux. I want this information because actually, I have a field that is in floating point type but after conversion, it comes as a…
Ibrahima Keita
  • 38
  • 5
1
vote
2 answers

SSconvert convets date to YYYY-MM-DD irrespective of xlsx date format

I am using ssconvert to convert xlsx to csv. One of the column has date field so when I convert it into csv date column value has converted into YYYY-MM-DD Input: Name Date Test 05/08/2021 Command: ssconvert test.xlsx …
user13000875
  • 387
  • 2
  • 14
1
vote
1 answer

Batch convert xlsx to csv, all sheets with a pattern, if they have data, in linux

I need to convert a lot of XLSX files to CSV, but each file has tabs, which must be converted to individual files if they have data in them. In addition, I need to convert only those tabs that follow a pattern in their name, for example, "Tab1". So…
RafaV
  • 21
  • 3
1
vote
0 answers

XLSX to CSV or .txt "assertion failed" error

I am attempting to convert an Excel file (test.xlsx, created in Office Professional Plus 2013) into either CSV or TXT format using SSCONVERT. Using the command line, with and without identifying the importer (Gnumeric_Excel:excel_xml). In either…
Alan MacNeill
  • 11
  • 2
1
vote
1 answer

ssconvert returns killed with no output

I am using ssconvert (Gnumeric) to convert large Excel files into separate CSV files. Most files work, however with some of the larger files with additional formatting the process dies abruptly and says 'killed'. ssconvert -S '/tmp/inputfile.xlsx'…
Daniel
  • 63
  • 6
1
2