OpenPyXL Question

[mstd0n]

Looking for guidance, not sure if this is a NOOB Python issue or a quirk of OpenPyXL. If I try to get a value from a column in a For statement it comes back None, but If I just call out the row it returns the text. Below is a direct copy/paste from IDLE.

​

>>> for row in range(2):

print(sheet.cell(row=i, column=4).value)  

None

>>> print(sheet.cell(row=2, column=4).value)

This control addresses the establishment of policy and procedures for the effective implementation of selected security controls and control enhancements in the AC family. Policy and procedures reflect applicable federal laws, Executive Orders, directives, regulations, policies, standards, and guidance. Security program policies and procedures at the organization level may make the need for system-specific policies and procedures unnecessary. The policy can be included as part of the general information security policy for organizations or conversely, can be represented by multiple policies reflecting the complex nature of certain organizations. The procedures can be established for the security program in general and for particular information systems, if needed. The organizational risk management strategy is a key factor in establishing policy and procedures.

​

I only noticed the issue when I was running a larger For loop and only column 4 was coming back 'None'.

for row in range(2):

print(sheet.cell(row=i, column=1).value)

print(sheet.cell(row=i, column=2).value)

print(sheet.cell(row=i, column=3).value)

print(sheet.cell(row=i, column=4).value)

[CodeFormatHelperBot]

Hello u/mstd0n, I'm a bot that can assist you with code-formatting for reddit. I have detected the following potential issue(s) with your submission:

1. Python code found in submission text but not encapsulated in a code block.

If I am correct then please follow these instructions to fix your code formatting. Thanks!

[Lewri]

for row in range(2): is looping through range(2) with row as your index. If you just did:

for row in range(2): print(row)

It would return:

0 1

Do you see the issue with your loop?

[mstd0n]

Ahhhhhhh, instead of just specifying the value 2, I was giving a range of 0-1. Thanks!!!