Category Archives: Office

ssconvert, Cara Konversi File .csv ke .xls atau .xlsx Excel di Terminal Linux

Pertama install terlebih dulu GNUmeric Excel melalui terminal
CentOS

yum install gnumeric

Debian

apt-get install gnumeric

Cara menggunakannya, sangat mudah:

ssconvert antorij.csv antorij.xls

Contoh outputnya

[root@antorij 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.