python编写execl文件方法

#!/usr/bin/env python
import xlwt
#初始化workbook对象
workbook = xlwt.Workbook()
#然后添加一个workbook对象
sheet = workbook.add_sheet('sheet1', cell_overwrite_ok=True)
#写入表头
sheet.write(0, 0, 'ssh_err')
#逐行插入内容
j = 1
for i in range(1, 5):
    addr = '192.168.1.' + str(i)
    sheet.write(j, 0, addr)
    j += 1
#写入表头
sheet.write(0, 1, 'ping_err')
#逐行插入内容
j = 1
for i in range(14, 25):
    addr = '192.168.11.' + str(i)
    sheet.write(j, 1, addr)
    j += 1
#保存文件
workbook.save('./new.xls')