数据存储在execl表和自动换行和宽高

import xlwt
def write_xlm():
    f = xlwt.Workbook()
    sheet1 = f.add_sheet('学生', cell_overwrite_ok=True)
    row0 = ["id","姓名", "年龄", "出生日期", "爱好"]
    colum0 = ["张三", "李四", "恋习", "小明", "小红", "无名"]
    for i in range(0, len(row0)):
        sheet1.write(0, i, row0[i])  #写入到1行，第i列里面
    for i in range(0, len(colum0)):
        sheet1.write(i+1,1,colum0[i])  #写入到i+1行，第2列里面
    sheet1.write(6, 3, '2006/12/12') #写入到第7行，第4列里面
    sheet1.write_merge(4, 5, 3, 3, '打篮球') #把第5行的第4列和第6行的第4列合并
    sheet1.write_merge(4, 5, 5, 7, '游戏')  #相当于把鼠标放在第5行的第6列上拖动到把第6行的第8列合并
    f.save('1test.xls')
write_xlm()

execl内容

---

import xlwt
def write_xlm():
    f = xlwt.Workb