Presently, I am using excel interface with JAVA using jcom library
As you know, Excel has columns: A,B,C....Z,AA,AB,AC,......,AZ,BA,BB,....BZ,CA... and so on
My problem is that I want to create a function in JAVA whose prototype is:
String getColName(String col,int add)
you can understand working of this function by following examples:
getColName("H",0) returns "H", getColName("H",3) returns "K"
getColName("Y",3) returns "AB",getColName("AZ",5) returns "HE"
And So On
I hope, u understand that what kind of function, I want to create
Please tell me the logic behind it.