I have an excel spreadsheet that I am managing using OpenPyXL and it looks like this:
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
没有评论:
发表评论