ssconvert, Cara Konversi File .csv ke .xls atau .xlsx Excel di Terminal Linux
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.