# import sys
# sys.path.append(r"C:\Users\lyhhh\AppData\Local\Programs\Python\Python313\Lib\site-packages")

import xlrd

# 1. 先打开xlsx文件
xlsx = xlrd.open_workbook(r"D:\视频\learning-python\test.xlsx")
# 2. 获取指定的标签页
table = xlsx.sheet_by_index(0)
# 3. 获取到表格中有多少行
nrows = table.nrows
# 4. 进行循环统计操作
total = 0
count = 0
for i in range(1,nrows):
    print('----------------------------------')
    classId1 = table.cell_value(i,0)
    classId2 = table.cell_value(i,1)
    classId3 = table.cell_value(i,2)
    print(classId1,classId2,classId3)