python - 使用 XLRD 模块在导入的 excel 文件中搜索字符串

Question

我有一个大约 1000 行和 25 列宽的 excel 文件。

我想要做的是创建一个脚本，根据用户输入查看 excel 文件。 (本例中的名称)

我当前的代码如下:

import xlrd
file_location =r"C:\Users\extoskben\Desktop\Datorer.xlsx"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
User = input("What's the users name?:   ")

我希望代码从 excel 文件中读取，并根据它匹配的名称从所有列中打印结果。

编辑:

excel文件的结构:

   [Name         ] [x] [x] [x] [Serialnumber] [x] [x] [   Model    ]
[1] Oskar Beneke    x   x   x   123456789      x   x  Thinkpad t470
[2] Example name    x   x   x   987654321      x   x  Thinkpad t470s

我想知道如何仅打印第 1、5 和 8 行的结果，并从我的打印中留下“X”。

Answer 1

此代码执行您想要的操作:

import xlrd
file_location =r"C:\Users\extoskben\Desktop\Datorer.xlsx"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
User = input("What's the users name?:   ")

for row in range(sheet.nrows):  # Iterate over every rows of the file
    if User == sheet.cell_value(row, 0):  # If the user name match the input
        for col in range(sheet.row_len(row)):  # Iterate over every columns of the cell
            print(str(sheet.cell_value(row, col)))  # Print the value of the cells.

编辑:

如果您只想打印给定行的特定列(本例中的第一、第五和第八列)，您可以使用这个版本的 for 循环:

columns_to_output = [0, 4, 7]  # List of columns to ouptput (starting with `0` for first column index)
for row in range(sheet.nrows):  # Iterate over every rows of the file
    if User == sheet.cell_value(row, 0):  # If the user name match the input
        for col in columns_to_output:  # Iterate over the column to output list
            print(str(sheet.cell_value(row, col)))  # Printing the cell at given column in the row.