Sep-17-2018, 08:11 PM
Thanks for the input Larz60+
Still can't seem to find reference in those links that help.
I have now started to get somewhere with the following:
Getting closer.
Still can't seem to find reference in those links that help.
I have now started to get somewhere with the following:
# Import `load_workbook` module from `openpyxl` from openpyxl import load_workbook # Load in the workbook wb = load_workbook('mystuff.xlsx') # Get sheet names print(wb.sheetnames) #activate a sheet into array sheet = wb['Sheet1'] #print value of A1 print(sheet['A1'].value) for row in sheet.iter_rows(): for cell in row: #if cell.value in row > '1': #print(cell.value) print(cell.value)Having trouble applying a condition inside the for loop.
Getting closer.