#!/bin/bash
HAEX="./HaExcel.exe"
SSCNV="./ssconvert.exe"
EXP="./exports/"

if [ -z "$1" ]; then
        echo "Usage: $0 [Excel files directory]"
        exit
fi

for i in `ls $1//*.xls | sed -e "s/ /^/g"`; do
        fdir=`echo "$i" | sed -e "s/\^/ /g"`
        fname=`expr "$fdir" : '.*//\(.*\)\..*'`
        oname="$EXP$fname.gnumeric"
        o2name="$EXP$fname.HAX.gnumeric"
        echo "SSCNV: $fdir > $oname"
        $SSCNV "$fdir" "$oname"
        $HAEX -m -i "$oname" -o "$o2name"
        $HAEX -s -i "$oname" -o "$o2name"
done