利用xlrd库实现表格内数据的提取与输出

import xlrd

def read_excel(file_path):
    workbook = xlrd.open_workbook(file_path)
    sheet = workbook.sheet_by_index(0)

    # 获取标题行
    title_row = sheet.row_values(0)
    title = "，".join(title_row)
    print(title)

    for row in range(1, sheet.nrows):
        name = sheet.cell_value(row, 0)
        price = int(sheet.cell_value(row, 1))
        print(f"商品名称: {name}\n价格: {price}\n")