python - 如何在Python中读取和打印Excel文件中的随机行？

Question

我正在尝试创建一个脚本，该脚本将从 Excel 文件中输出随机行。从本质上讲，这就像学习用的抽认卡。我希望一次输出一行随机数据。到目前为止我所拥有的如下；我知道我要离开并需要一些帮助。

import xlrd
import random
loc = ("FILE PATH")

wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(0)

sheet.cell_value(0,0)

for i in range(sheet)
    print(random.sheet.row_values)

Answer 1

您可以从这样的内容开始，然后根据需要进行编辑。

import xlrd 
import random 

# path to file:
path_to_file = "path/to/spreadsheet.xlsx"

# get, set workbook, sheet:
work_book = xlrd.open_workbook(path_to_file) 
sheet = work_book.sheet_by_index(0)

# infinite loop:
while True:

    # ask user to continue:
    input('Print next row?: ')

    # get a random index between 0 and total number of rows:
    random_index = random.randrange(0, sheet.nrows)

    # print row:
    print(sheet.row(random_index))