Oct-04-2017, 11:50 PM
(This post was last modified: Oct-04-2017, 11:51 PM by Pedroski55.)
Thanks for your trouble, I appreciate it! I am still tinkering with this and it is STILL not working.
Attached is a screen shot of the output file. You can see that row 4, column 2 is the first student number. I tried the insert the values in column 8, then column 12. I always save as a copy, just to be careful.
This is from the interactive shell:
The key is correct, starting at row 4, column 2 and the value is correct, 16:
Can anyone see what the problem is? Why do I not get the 'value' in the correct row and column?
EDIT: I finally answered my own question! If I write int(key) it works!!
Attached is a screen shot of the output file. You can see that row 4, column 2 is the first student number. I tried the insert the values in column 8, then column 12. I always save as a copy, just to be careful.
This is from the interactive shell:
Quote:>>> activeSheetwb2.cell(row=4, column=2).value
'1625010401'
>>> StudentNumAndScore[1625010401]
16
>>> key = 1625010401
>>> value = StudentNumAndScore.get(key,'nix')
>>> value
16
The key is correct, starting at row 4, column 2 and the value is correct, 16:
for rowNum in range(4, maxRow2 + 1): key = activeSheetwb2.cell(row=rowNum, column=2).value value = StudentNumAndScore.get(key, 'nix') activeSheetwb2.cell(row=rowNum, column=12, value=value)If a key is not found, I set the value 'nix', meaning 'nothing'. From the screenshot, you can see, all I get is 'nix'.
Can anyone see what the problem is? Why do I not get the 'value' in the correct row and column?
EDIT: I finally answered my own question! If I write int(key) it works!!
for rowNum in range(4, 10): key = activeSheetwb2.cell(row=rowNum, column=2).value value = StudentNumAndScore.get(int(key), 'nix') print(key, value)
Quote:1625010401 16
1625010402 15
1625010404 16
1625010405 17
1625010406 15
1625010407 18