Category Archives: Office

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.