xlwt与xlrd只能针对xls格式的excel进行操作,如果想对xlsx格式进行操作请使用openpyxl模板对excel进行操作
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)
本文主要讲解了python使用xlwt与xlrd操作excel的知识,更多关于python操作excel的文章请查看下面的相关链接