I am trying to print the content in a specific cell. i know the cells i want to check before extracting the content to the output. i am using multiple IF statements for this :
if lineCount == 5:
if line[0]:
print line[0], 'A5'
OPfound = 1
break
if line[1]:
print line[1], 'B5'
OPfound = 1
break
if lineCount == 4:
if line[0]:
print line[0], 'A4'
OPfound = 1
break
if line[1]:
print line[1],'B4'
OPfound = 1
break
The output is in the form :- extracted content, cell number
what i am trying to do is first check if there is any content in A5 - if there is content then extract it...else check for content in B5 - if there is content then extract it...else check content in A4
i am getting output for B5 and A4...but NOT FOR A5
also how do i check content in B4 ONLY if there is no content in A5,B5 and A4...
Darian Moody has a nice solution to this challenge in his blog post:
a = 1
b = 2
c = True
rules = [a == 1,
b == 2,
c == True]
if all(rules):
print("Success!")
The all() method returns True when all elements in the given iterable are true. If not, it returns False.
You can read a little more about it in the python docs here and more information and examples here.
(I also answered the similar question with this info here - How to have multiple conditions for one if statement in python)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With