python中excel的写入与读取

# 写入
# 导入模块
import xlsxwriter
# 打开excle 文件
workbook=xlsxwriter.Workbook("student.xlsx")
# 创建一张工作表
worksheet=workbook.add_worksheet("Sheet1")
worksheet.write(0,0,"学号")
worksheet.write(0,1,"姓名")
worksheet.write(0,2,"年龄")
student_list=[{"name":"小红","age":20,"no":"20189899889"},
              {"name": "小明", "age": 22, "no": "201898998859"},
              {"name": "小号", "age": 23, "no": "201898998869"},
              {"name": "小比", "age": 25, "no": "201898998879"},
              {"name": "小将", "age": 26, "no": "201898998899"},]
for i,info in enumerate(student_list):
    worksheet.write(i+1,0,info["no"])
    worksheet.write(i+1,1,info["name"])
    worksheet.write(i+1,2,info["age"])
workbook.close()

# 读取
# 导入模块
import  xlrd
# 读取文件
data=xlrd.open_workbook("测试流.xlsx")
# 获取列表
table=data.sheet_by_index(0)
# 获取行数
nrows=table.nrows
# 获取列表
info_list=[]
ncols=table.ncols
print(nrows,ncols)
first_row =table.row_values(0)
# print(first_row)
for rownum in range(1,nrows):
    row=table.row_values(rownum)
    if row:
        info_list.append(row)
    for i in info_list:
        print(i)