0

I'm trying to search for a username -within a xlsx- 'saito' (I added this to the xslx manually) and most of the answers online work only when you search for a specific cell. My intention is to make a login program where I can search for a username and if the username exists in the file then ask for the related password after, still can't find out how to search for a string though.

Below is my current code...

counter = 0 
print('type L to log in or C to create an account')
decision = input().lower()
if decision == 'l':
    while counter == 0:
        print('please enter your user name')
        username = input()
        while username == '':
            print('please enter a valid username')
            username = input()
        if username in Accounts.xlsx:
            print('please enter your password')
            counter = counter + 1
        else:
            print('The username you have entered has not been recognised, please try again')
elif decision == 'c':
    print('I'll do the user creation later')
else:
    print('please log in or create a user')

Accounts.xlsx is the file I will be using to search for the usernames.

OneCricketeer
  • 179,855
  • 19
  • 132
  • 245
Luis Alencastro
  • 3
  • 1
  • 5
  • 1
    This answer may be helpful: https://stackoverflow.com/questions/38056233/python-search-excel-sheet-for-specific-strings-in-a-column-and-extract-those-ro – Stanislav Ivanov Sep 17 '17 at 19:50
  • You could learn Pandas. https://stackoverflow.com/questions/17063458/reading-an-excel-file-in-python-using-pandas – OneCricketeer Sep 17 '17 at 20:34

1 Answers1

1

Openpyxl is very useful for working with .xlsx files. If you just want to check whether a username is anywhere in the file, you can extract all of the values like so:

from openpyxl import load_workbook

wb = load_workbook(filename='Accounts.xlsx')
sheet = wb['sheet_name']

names = []

for i in range(1, sheet.max_row + 1):
    for j in range(sheet.max_column):
        if sheet[i][j].value:
            names.append(sheet[i][j].value)

Then just check whether a username is in the list

if username in names:
MartinBorak
  • 26
  • 1