需要安装xlwt
下载地址:https://pypi.org/project/xlwt/
下载后解压,然后执行它的setup.py脚本: python setup.py install
然后就可以开始用了 import xlwt
效果:
代码:
#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)
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。