Python Forum

Hello, I am doing an assignment and not sure what im doing wrong. My job is to search the columns and rows of an excel file using openpxyl. So far I have got this code done.

import openpyxl

def functionOne ():
    print("Please enter the word you would like to find in the excel sheet.")
    userGuess = input()

    sampleWorkbook = openpyxl.load_workbook("c:\\Assignment.xlsx")
    sheet = sampleWorkbook.active

    for col in sheet.iter_cols(min_row=1, max_col=4, max_row=100):
        for cell in col:
            if userGuess == cell:
                print(cell)

functionOne ()

So, I need to output the column and row ID if the word was found in the list.
Each column has 100 words and there is 4 rows.

When I have entered a word that I know thats in the file I get nothing back.
I have tried replacing the part of the code:
if userGuess == cell:
print(cell)
with print (cell)
and I get the word that is in the file outputted back to me.

I'm new to programming so Im not sure what I'm doing wrong here.

Thanks.

If you start loop on iter_rows instead ,then can get back info like cell.value, cell.row..,ect.
Example:

from openpyxl import Workbook
import openpyxl

file = "email.xlsx"
wb = openpyxl.load_workbook(file)
ws = wb.worksheets[0]

search_word = 'Taxi'
for row in ws.iter_rows():
    for cell in row:
        if search_word in cell.value:
            print(f'{cell.value} at row: {cell.row} and column: {cell.column} In cell {cell}')

Output:
Taxi at row: 4 and column: 1 In cell <Cell 'sheet1'.A4>