Assigning iter_row value to variable

[ankey]

Thanks for the help. Here's the full code:

# Import `load_workbook` module from `openpyxl`
from openpyxl import load_workbook

# Load in the workbook
wb = load_workbook('myFile.xlsx')

#activate a sheet into array
sheet = wb['Sheet1']

# select all populated rows and iterate through		
for row in sheet.iter_rows(min_col=1, min_row=1, max_col=2, max_row=sheet.max_row):
	# occur = int(row[1].value) 
	if int(row[1].value) == 1:
		pass
	else: 
		print(row[0].value)

And error:

Output:
---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
C:\python\openpyxl_test.py in <module>()
     11 for row in sheet.iter_rows(min_col=1, min_row=1, max_col=2, max_row=sheet.max_row):
     12         # occur = int(row[1].value)
---> 13         if int(row[1].value) == 1:
     14                 pass
     15         else:

ValueError: invalid literal for int() with base 10: 'occurances'