How can I make python find this word on an excel sheet?

Question

I am trying to make python find a specific word in an excel sheet. Nonetheless, despite searching literally everywhere how to do this, I can't find an answer.

import re

with open('ptry.xlsx') as aa:
    for line in aa:
        match = re.search(r'abc', line)
        if match:
            print("yes")
        else:
            print ("no")

This code gives me the following result:

no
no
no
no
no
no
no
no
no
no
no
no
no
no
no
no
no
no
no

Repl Closed

Nonetheless, I am expecting a simple "yes" as the word "abc" is on my excel sheet.

Perhaps this thread is of help to you: stackoverflow.com/questions/16888888/… Read the Exel file properly and iterate over its cells to check for abc. — Jens
– Jens, Commented Oct 22, 2019 at 0:11

user9022647 · Accepted Answer · 2019-10-22 01:18:49Z

1

If you are using Excel, can I suggest using Openpyxl?

import os
#Change to the dir of your spreadsheet

from openpyxl import load_workbook

wb = load_workbook(filename='Insert your file here', data_only=True)
#data_only=False by default
#If you want to see data instead of formulas, set data_only=True

ws = wb['Sheet1'] #Or whatever your sheet name is

for num_row in range (1, ws.max_row):
    if ws['A{}'.format(num_row)].value=='abc':
        print ('yes')
    else:
        print ('no')
#You can also use ws.max_column

This should give you a general idea of using openpyxl. Let me know if you have any other questions.

answered Oct 22, 2019 at 1:18

user9022647

Sign up to request clarification or add additional context in comments.

1 Comment

Fcas Over a year ago

Thank you Sen, this worked perfectly fine! Also, thanks to all of you who suggested some answers, they were very much appreciated.

JJSSEE · Accepted Answer · 2019-10-22 01:27:19Z

1

There may be a better way, but this one does the trick. In the code below a copy of the excel file is created in a text format and then a list is created and checked for the "word" in the file.

import pandas as pd

df = pd.read_excel("ptry.xlsx")
df.to_csv("ptry.txt")

filex = open("ptry.txt", "r")
filex_string = filex.read()
filex_list = filex_string.split(",")

if "word" in filex_list:
    print("True")
else:
    print("false")

edited Oct 22, 2019 at 1:27

answered Oct 22, 2019 at 1:20

JJSSEE

296 bronze badges

Comments

user5680356 · Accepted Answer · 2019-10-22 01:25:27Z

0

import openpyxl

excel_var = openpyxl.load_workbook('excelname.xlsx')

sheet = excel_name.get_sheet_by_name('sheetname')

for row in sheet.iter_rows(min_row=minr, min_col=5, max_col=11, max_row=maxr):
    match = re.search(r'abc', line)
    if match:
        print("yes")
    else:
        print("no")

Take a note you should limit the rows and cols in the for loop there is a vars minr and maxr

answered Oct 22, 2019 at 1:25

user5680356

Collectives™ on Stack Overflow

How can I make python find this word on an excel sheet?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related