Article ID: 198112
Article Last Modified on 3/21/2005
// Converts (row,col) indices to an Excel-style A1:C1 string
char *IndexToString(int row, int col, char *strResult)
{
if(col > 26)
sprintf(strResult, "%c%c%d",
'A'+(col-1)/26-1, 'A'+(col-1)%26, row);
else
sprintf(strResult, "%c%d", 'A' + (col-1)%26, row);
return strResult;
}
Some examples of the conversion:
Calling IndexToString() with row=1 and col=26 yields "Z1"
Calling IndexToString() with row=1 and col=27 yields "AA1"
Calling IndexToString() with row=2 and col=52 yields "AZ2"
Calling IndexToString() with row=2 and col=53 yields "BA2"
Calling IndexToString() with row=10 and col=10 yields "J10"
Additional query words: excel convert
Keywords: kbhowto KB198112