pip install xlwt

import xlwt

book = xlwt.Workbook()

sheet1 = book.add_sheet("姓名和電話")
???????sheet2 = book.add_sheet("詳情")

sheet1.write(0, 0, "姓名")

#新建字體
font = xlwt.Font()
font.name = "楷體"
???????font.bold = True

style = xlwt.XFStyle()
???????style.font = font

sheet1.write(0, 1, "電話", style)

for i in range(10):
    sheet1.write(i + 1, 0, f"名字{i+1}")
???????    sheet1.write(i + 1, 1, f"電話{i+1}")

book.save("學生信息.xls")

pip install xlrd

import xlrd

book = xlrd.open_workbook("學生信息.xls")

sheets = book.sheet_names()
print(sheets)

# (1)索引獲取
sheet1 = book.sheet_by_index(0)
print(sheet1)
# (2)表名獲取
sheet2 = book.sheet_by_name("詳情")
print(sheet2)

rows = sheet1.nrows
print(rows)

cols = sheet1.ncols
print(cols)

row_len = sheet1.row_len(0)
print(row_len)

row_values = sheet1.row_values(1)
print(row_values)

row_values = sheet1.row_slice(0, 0, 1)
print(row_values)

col_values = sheet1.col_values(1)
print(col_values)

col_values = sheet1.col_slice(0, 0, 11)
print(col_values)

cell_value = sheet1.cell(0, 1).value
print(cell_value)