本体: $99.95 メール便(Express): $29.95 Total: $129.90円高のおかげで 10600円
0 | 0 | A0 | 27*1+0 | B0 | 27*2+0 | ||
A | 1 | AA | 27*1+1 | BA | 27*2+1 | ||
B | 2 | AB | 27*1+2 | BB | 27*2+2 | ||
C | 3 | AC | 27*1+3 | BC | 27*2+3 | ||
... | ... | ... | |||||
Y | 25 | AY | 27*1+25 | BY | 27*2+25 | ||
Z | 26 | AZ | 27*1+26 | BZ | 27*2+26 |
String[] COL_NAME = new String[]{"0","A","B","C", ... ,"Y","Z"}; String colName(int colNum) { if (colNum < 27) { return COL_NAME[colNum]; } return colName(colNum / 27) + COL_NAME[colNum % 27]; }
A | 1 | AA | 26*1+1 | BA | 26*2+1 | ||
B | 2 | AB | 26*1+2 | BB | 26*2+2 | ||
C | 3 | AC | 26*1+3 | BC | 26*2+3 | ||
... | ... | ... | |||||
Y | 25 | AY | 26*1+25 | BY | 26*2+25 | ||
Z | 26 | AZ | 26*1+26 | BZ | 26*2+26 |
String colName(int colNum) { if (colNum < 27) { return Character.toString((char)( (colNum % 26) + 'A' - 1)); } if (colNum % 26 == 0) { // 末尾は Z return colName((colNum - 26) / 26) + "Z"; } return colName(colNum / 26) + Character.toString((char)( (colNum % 26) + 'A' - 1)); }