The information in this article applies to:
SUMMARYSometimes it is necessary to convert numerical indices (row,column) into Excel-style "A1:C1" string notation. This can be confusing because after "Z," Excel starts using "BA," "BB," etc. This article contains a function you can use in your code to do this conversion for you. MORE INFORMATIONC++ code:
Some examples of the conversion:
Calling IndexToString() with row=1 and col=26 yields "Z1" © Microsoft Corporation 1998, All Rights Reserved. Additional query words: excel convert
Keywords : kbExcel kbVC400 kbVC410 kbVC420 kbVC500 kbVC600 |
Last Reviewed: October 12, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |