@
Yoriz --
i have an excel workbook that will have period separated values.
As an example like the below
1.1.1.1
1.2.1.1
1.1.2.1
2.1.1.1
2.1.2.1
2.2.2.1
1.1.1.1
1.1.1.1
2.1.1.1
In the above list we have duplicate values. I need each unique value in the list to be assigned an alphabetical value, starting with A.
(using proper python this time)
A = 1.1.1.1
B = 1.2.1.1
C = 1.1.2.1
D = 2.1.1.1
E = 2.1.2.1
F = 2.2.2.1
A = 1.1.1.1
A = 1.1.1.1
D = 2.1.1.1
how can I auto assign the alphabetical value to the period separated values?
--------------------------------------------------------------------------------------------------------
@
bowlofred -
I am scanning the excel workbook and creating the period separated list like so
mr2 = ws2.max_row
mc2 = ws2.max_column
for y in range(2, mr2):
strValue = ''
for x in range(2, mc2):
strValue = strValue + '.' + str(ws2.cell(y, x).value)
strValue = strValue[1:]
ws2.cell(y, mc2 + 1).value = strValue
Does that answer your question?