python lxwt，xlrd基本操作

• 创建一个工作簿

import xlwt
workbook=xlwt.Workbook()

• 写入

	sheet.write(0,0,"姓名")
    sheet.write(1,0,"小猪")
    sheet.write(1,1,"1")

• 保存

workbook.save(os.path.join(os.getcwd(),"result.xls"))

• 读取等操作

workbook=xlrd.open_workbook(os.path.join(os.getcwd(),"result.xls"))     #打开文件
    sheet=workbook.sheets()[0]        #拿到表1
    rows=sheet.nrows        #获取行数
    for row in range(0,rows):       #以行为单位获取内容
        print(sheet.row_values(row))