py写入xlsx

写入

import xlwt

workbook = xlwt.Workbook()
sheet1 = workbook.add_sheet( 'sheet1' ,cell_overwrite_ok = True )
sheet2 = workbook.add_sheet( 'sheet2' ,cell_overwrite_ok = True )

sheet1.write( 0 , 0 , '0' )
sheet1.write( 0 , 1 , '1' )
sheet1.write( 1 , 1 , '2' )
sheet1.write( 1 , 2 , '3' )
sheet2.write( 0 , 0 , 'this should overwrite2' )
sheet2.write( 1 , 2 , 'bbbbbbbbbbbbb' )
"""
#-----------使用样式-----------------------------------
#初始化样式
style = xlwt.XFStyle()
#为样式创建字体
font = xlwt.Font()
font.name = 'Times New Roman'
font.bold = True
#设置样式的字体
style.font = font
#使用样式
sheet.write(0,1,'some bold Times text',style)
"""

workbook.save('C:\\Users\\刘傲\\Desktop\\test3.xls')
print('创建excel文件完成！')