Gnumeric has tools to automate and manipulate spreadsheet files from command line interface. It can be used to create spreadsheet from CSV files, convert between different file formats like f,e: XLS, ODS, HTML, LaTeX, PDF and many more. Below are listed a few examplesfor spreadsheet manipulation.
Merge all csv files in current directory into a spreadsheet named test.xls, using gnumeric automation command:
ssconvert -merge-to=output.ods *.csv
ssconvert --merge-to=output.xls one.csv two.csv three.csv ...
To convert a gnumeric spreadsheet f.e. table.gnumeric to a Microsoft Excel format table.xls use:
ssconvert table.gnumeric table.xls
Convert to a Libreoffice file:
ssconvert table.gnumeric table.ods
Export a spreadsheet to a Portable Document File:
ssconvert table.ods table.pdf