python写excel

#coding:utf-8
 
import xlwt
 
if __name__ == '__main__':
    filepath = 'test.xls'
    workbook = xlwt.Workbook(encoding = 'utf-8')
    worksheet = workbook.add_sheet('sheet0')
    
    style = xlwt.XFStyle() # 初始化样式
    alignment = xlwt.Alignment() # Create Alignment
    alignment.horz = xlwt.Alignment.HORZ_LEFT  # May be: HORZ_GENERAL, HORZ_LEFT, HORZ_CENTER, HORZ_RIGHT, HORZ_FILLED, HORZ_JUSTIFIED, HORZ_CENTER_ACROSS_SEL, HORZ_DISTRIBUTED
    alignment.vert = xlwt.Alignment.VERT_TOP   # May be: VERT_TOP, VERT_CENTER, VERT_BOTTOM, VERT_JUSTIFIED, VERT_DISTRIBUTED
    alignment.wrap = 1  #自动换行
    style.alignment = alignment
 
    worksheet.write(0, 0, 'id', style)
    worksheet.col(0).width = 2000
 
    worksheet.write(0, 1, '姓名', style)
    worksheet.col(1).width = 3000
 
    worksheet.write(1, 0, '1', style)
    worksheet.col(0).width = 2000
 
    worksheet.write(1, 1, '汤姆', style)
    worksheet.col(1).width = 3000
 
    workbook.save(filepath)