用Pandas或其他东西从excel打印整行？

Question

你好，我需要一些帮助，我试着这样做约2小时，我在互联网上寻找，但我找不到任何解决办法， 我想从excel打印从我找到的名字水平行 这是我要打印的图片https://imgur.com/a/lZduGCV

elif "name " in data:
    baza = pd.read_excel('Baza.xlsx')
    data = data.split(" ")
    name = data[1]
    botgovor("Hold a second.I will check data base for that name")
    for name in baza:
        botgovor("We have that name in database,What would you like to do with it?")
        data = covekgovor()
        robot(data)
        if "check it" in data:
            informacije = pd.read_excel('Baza.xlsx')
            botgovor(informacije)

Answer 1

import xlrd

loc = ("excel_file.xlsx") # excel file name
wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(0)
sheet.cell_value(0, 0)
search_name = "Landon"

for i in range(sheet.nrows):
    if search_name == sheet.cell_value(i, 0):
        print(sheet.row_values(i))