Skip to content

Instantly share code, notes, and snippets.

@pontikos
Created February 12, 2015 12:59
Show Gist options
  • Select an option

  • Save pontikos/dde7f68bc9baffb5ecd3 to your computer and use it in GitHub Desktop.

Select an option

Save pontikos/dde7f68bc9baffb5ecd3 to your computer and use it in GitHub Desktop.
Convert excel spreadsheet to csv using https://github.com/dilshod/xlsx2csv
#!/bin/bash
#$ -S /bin/bash
#$ -o /dev/null
#$ -e /dev/null
#$ -cwd
#$ -V
#$ -R y
#$ -pe smp 1
#$ -l scr=1G
#$ -l tmem=2G,h_vmem=1G
#$ -l h_rt=5:0:0
#$ -t 1-257
set -u
set -x
let "SGE_TASK_ID=$SGE_TASK_ID-1"
scriptname=`basename $0`
mkdir -p ${scriptname}.qsub.out ${scriptname}.qsub.err
exec >${scriptname}.qsub.out/${scriptname}_${SGE_TASK_ID}_${JOB_ID}.out 2>${scriptname}.qsub.err/${scriptname}_${SGE_TASK_ID}_${JOB_ID}.err
args=`ls -1 *.xlsx`
f=${args[$SGE_TASK_ID]}
~/bin/xlsx2csv.py $x ${x/.xlsx/.csv}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment