Pertama install terlebih dulu GNUmeric Excel melalui terminal. Master GNUmeric disimpan di repository epel, jadi pastikan repository epel sudah terinstall.
CentOS
yum install gnumeric
Debian
apt-get install gnumeric
Cara menggunakannya, sangat mudah:
ssconvert rahmatriyanto.xls rahmatriyanto.csv
Banyak files sekaligus
find . -maxdepth 1 -name "*.xlsx" -exec ssconvert {} --export-type=Gnumeric_stf:stf_csv \;
Contoh outputnya
[root@rahmatriyanto data]# yum install gnumeric Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile * base: mirror.axarva.id * epel: rndc.xtremenitro.org * extras: download.nus.edu.sg * rpmfusion-free-updates: mirror.smartmedia.net.id * updates: mirror.readyspace.com Resolving Dependencies --> Running transaction check ---> Package gnumeric.x86_64 1:1.10.10-2.el6.1 will be installed --> Processing Dependency: libgoffice-0.8.so.8()(64bit) for package: 1:gnumeric-1.10.10-2.el6.1.x86_64 --> Running transaction check ---> Package goffice.x86_64 0:0.8.12-1.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: gnumeric x86_64 1:1.10.10-2.el6.1 epel 10 M Installing for dependencies: goffice x86_64 0.8.12-1.el6 epel 1.4 M Transaction Summary ================================================================================ Install 2 Package(s) Total download size: 12 M Installed size: 31 M Is this ok [y/N]: y Downloading Packages: (1/2): gnumeric-1.10.10-2.el6.1.x86_64.rpm | 10 MB 01:48 (2/2): goffice-0.8.12-1.el6.x86_64.rpm | 1.4 MB 00:20 -------------------------------------------------------------------------------- Total 91 kB/s | 12 MB 02:09 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : goffice-0.8.12-1.el6.x86_64 1/2 Installing : 1:gnumeric-1.10.10-2.el6.1.x86_64 2/2 Verifying : goffice-0.8.12-1.el6.x86_64 1/2 Verifying : 1:gnumeric-1.10.10-2.el6.1.x86_64 2/2 Installed: gnumeric.x86_64 1:1.10.10-2.el6.1 Dependency Installed: goffice.x86_64 0:0.8.12-1.el6 Complete!
Lalu apa manfaatnya? bukankah bisa menggunakan libreoffice atau microsoft ofice desktop version?. ssconvert sangat membantu jika kita memerlukan konversi file yang banyak atau berulang.