sentakuitaの日記: Excel列名変換問題(2).sh
日記 by
sentakuita
#!/bin/sh
#alpha2dec.sh
alpha=$1;dec=0;base=1
while ((${#alpha}));do
n=$((36#${alpha:${#alpha}-1:1}-9))
dec=$((dec+base*n))
base=$((base*26))
alpha=${alpha:0:${#alpha}-1}
done
echo $dec
Excel列名変換問題(2).sh More ログイン