首页 > IT职业 > IT职场 > python操作excel
#!/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()
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2971/viewspace-2809700/ ,如需转载,请注明出处,否则将追究法律责任。