Python: Can anyone help me in writing a script?

Accepted answer

Use Pandas for reading the excel file into a dataframe. Select that column in dataframe and apply str.contains() functions and save it into another new column into the dataframe. Save that dataframe back to excel.

+1

Rijwan Ansari5y ago

Hi,

You can use this script

import openpyxl as xl
workbook = xl.load_workbook(filename="test.xlsx")
title_column_name = "title"
# Get the active worksheet
ws = workbook.active
# The String we'll search for. You could prompt the user to provide
searchstring = "Grumpier"
# ws.rows[1:] means we'll skip the first row (the header row).
for row in ws.rows[1:]:
if row[1].value.find(searchstring) != -1:
print("Yes")
else
print("no")

0

Satya Karki5y ago

Try this

import win32com.client
# Connect to Excel server
xl = win32com.client.Dispatch("Excel.Application")
myfile = r'C:\temp\myworkbook.xls'
wb = xl.Workbooks.Open(Filename=myfile)
sht1 = wb.Sheets.Item(1)
match = sht1.Cells.Find('search string')
print(match.Formula)
wb.Close(SaveChanges=False)
xl.Quit()

+1