Needed this method for a simple conversion between numbers and columns for an Excel spreadsheet manipulation in Java. Some example runs and results:
getEquivColumn(0) = A
getEquivColumn(1) = B
getEquivColumn(26) = AA
getEquivColumn(52) = BA
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
public String getEquivColumn(int number){ String converted = ""; // Repeatedly divide the number by 26 and convert the // remainder into the appropriate letter. while (number >= 0) { int remainder = number % 26; converted = (char)(remainder + 'A') + converted; number = (number / 26) - 1; } return converted; } |
Cheers!
