3. python file Manipulation tool Xlsxwriter Tools

# _*_ Encoding:utf-8 _*_

Import Xlsxwriter

#创建xlsx后缀名的excel
Excel = Xlsxwriter. Workbook (R ' D:\github\file\xlswrite_test.xlsx ')

#添加sheet页名称
Sheet = excel.add_worksheet (' Device name ')

#设置行宽, Row height
Sheet.set_column (' A:c ', 30)
#设置excel样
Bold = Excel.add_format ({' Bold ': True})

#向excel写数据
Sheet.write (' A1 ', ' Hello ')

#向excel写数据, and set bold style
Sheet.write (' A2 ', u ' Hello ', bold)
Sheet.write (' B3 ', ' *&^%$#@! ')

Sheet.write (3,0,32)
Sheet.write (4,0,35.5)
Sheet.write (5,0, ' =sum (A4:A5) ')

#关闭excel
Excel.close ()

3. python file Manipulation tool Xlsxwriter Tools