Forum Discussion

BMD's avatar
BMD
Contributor
2 years ago

Converting Number to Matching Character 1=A, 2=B, 3=C....

I have a function that returns the data from a column in an Excel file - now I want to return the data for a row.  Below is the function that returns the column - in this case column = D and starting...
TCYKPB's avatar
TCYKPB
Contributor

well, you can make an array or a dictionary and work with indexes or keys, kind of like

alphabet = [null, "A", "B", "C", "D", ... etc]

and then reference the alphabet array with the index you are getting from your current function:

from

("C:\\Users\\TEST.xlsx", "STEP", 5, 3, 15)

to

("C:\\Users\\TEST.xlsx", "STEP", 5, alphabet[3], alphabet[15])

resulting in

("C:\\Users\\TEST.xlsx", "STEP", 5, "C", "O")

BMD's avatar
BMD
Contributor
2 years ago

Why didn't I think of this - Thank You - I think this will work and it's simple.

THANKS to TCYKPB