Why isn't my code finding the usernames or passwords in the file? How do you search through an excel file in python to find a stored value?

Question

for line in read: details = line.split(",") if details[index] == username: print("correct username") current = index if password == details[current + 1]: print("correct password") found = "true" ...

Answer 1

Fixed it: https://ideone.com/FAJxvb

Answer 2

You didn't show all your code so we have to guess what else you did. For example, you probably have
found = "false"
before your loop.

It would be better if you use boolean values rather than strings for that. If you used booleans then you would have
if not found:

If you used
read = readlines ()

then, after you use split (","),
details [1] will include the newline character and that could be your main problem.

You don't seem to be using current except in one place, so you could use
if password == details [index + 1]:
instead.

However, it seems you don't even want to do that. You should probably have
if details [0] == username:

Because details is re-created for each line of your input file, so then you would just have:
if password == details [1]:

and not use index at all. And, if you didn't get rid of the newline earlier, you could strip it with
if password == details [1] [:-1]:

In Python, it is important to show indentation (which Y!A removes) so either use "... " for each indentation level (with a blank space between each level), or use #end comments to delimit blocks, or use a code-posting site (ideone.com, codepad.org) and post the link here.

I've been assuming that you saved your sheet as a text file -- something that can be done with Excel.

Answer 3

Yep, a good practice when reading an unknown file or file type is to read and print off several records (and fields within those records) to see if you're getting what you expected.

Answer 4

Excel files aren't text files. You need a python package like openpyxl to access data in Excel files.

If it's a CSV file, then you are missing a loop after details = line.split(",") to loop over every index value (or more accurately, every other index value as only the even indexes have usernames)