直接学习：https://edu.csdn.net/course/play/24756/280721
Excel处理-cell的相关操作

import xlrd
workbook = xlrd.open_workbook('成绩表.xlsx')
sheet = workbook.sheet_by_index(0)
# 1、sheet.cell(row,col):获取指定行和列的cell对象 
# cell = sheet.cell(1,1) 
# print(cell.value)
# 2、sheet.row_slice(row,start_col,end_col):获取指定行的某几列cell对象
# cells = sheet.row_slice(1,1,4)
# for cell in cells:
#     print(cell.value)
# 3、sheet.col_slice(col,start_row,end_row):获取指定列的某几行cell对象
# cells = sheet.col_slice(0,1,18)
# for cell in cells:
#     print(cell.value)
# 4、sheet.cell_value(row,col):获取指定行和列的值
# cell_value = sheet.cell_value(0,1)
# print(cell_value)
# 5、sheet.row_values(row,start_col,end_col):获取指定行的某几列的值
# cell_values = sheet.row_values(1,1,18)
# print(cell_values)
# 6、sheet.col_values(col,start_row,end_row):获取指定行的某几列的值
cell_values = sheet.col_values(1,1,18)
print(cell_values)