更新时间:2022-09-13 19:31:23
#!/usr/bin/env python
#coding: utf-8
import xlsxwriter
workbook = xlsxwriter.Workbook('demo1.xlsx')
worksheet = workbook.add_worksheet()
worksheet.set_column('A:A', 30)
bold = workbook.add_format({'bold': True})
worksheet.write('A1', 'hello')
worksheet.write('A2', 'workd', bold)
worksheet.write('A2', 'workd', bold)
worksheet.write('B2', u'中文测试', bold)
worksheet.write(3, 0, 44)
worksheet.write(4, 0, 55)
worksheet.write(6, 0, '=SUM(A4:A5)')
workbook.close()
本文转自chenzudao51CTO博客,原文链接: http://blog.51cto.com/victor2016/2072181,如需转载请自行联系原作者