2021年3月24日星期三

Find the column for string in excel spreadsheet

I have an excel spreadsheet that I am managing using OpenPyXL and it looks like this:

enter image description here

Basically, I want to be able to find which row the user's input is in using OpenPyXl. For example:

toFind = input("Enter string to find: ")  # lets say toFind = 'test'    # program will print out: test is in column A, row 2    # if toFind = 'test3', the program will output: test3 is in column A, row 4  
https://stackoverflow.com/questions/66792929/find-the-column-for-string-in-excel-spreadsheet March 25, 2021 at 12:06PM

没有评论:

发表评论