Bash Scripts

How to convert xls files to csv in Linux

Submitted by Richard on Sun, 03/21/2010 - 04:56

Install xls2csv

yum -y install xls2csv

To convert your xls file to csv, just type this command:

convertxls2csv -x filename.xls -c filename.csv

This script is very useful if you have a lot of excel files to convert. This will help you save a lot of time than converting it one by one.

#!/bin/bash
for files in *.xls
do
convertxls2csv -x "$files" -c "${files%.*}.csv"
done

Submitted by Richard on Tue, 06/10/2008 - 03:42

I created an auto install script to install Asterisk 1.2 for CentOS 4 and CentOS 5. This script will install the following:

Before running these script, you must install the some software needed to compile Asterisk.
For CentOS 4:

yum install gcc kernel kernel-devel bison openssl-devel

For CentOS 5:

yum install gcc kernel kernel-devel bison openssl-devel libtermcap-devel ncurses-devel

kernel-smp-devel (instead of kernel-devel) is necessary if you are using a dual core processor.