Monthly Archives:: February 2011

Convert Column Number to Corresponding Excel Column Letters – Java

Posted by & filed under programming, tech.

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 public String getEquivColumn(int number){ String converted = “”; // Repeatedly divide the number by 26 and convert the // remainder into the appropriate letter…. Read more »