Python: Can anyone help me in writing a script?

Question

Python:
Can anyone help me in writing a script?
What I'm trying to do is scan a column of an excel sheet containing text and if a certain keyword is present in that column then the output is in yes/no in another column I use python

Rajanikant Hawaldar · 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.

Satya Karki · Answer

Try this import win32com.client # Connect to Excel server xl = win32com.client.Dispatch( "Excel.Application" ) myfile = r 'C:	emp\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()

Rijwan Ansari · Answer

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" )

Python: Can anyone help me in writing a script?

Answers (3)