python_xlwings

#xlwings
#creat excel and do some pro

import xlwings as xw
# APP函数，两个参数，一个是窗口是否可视，第二个是是否直接创建工作簿
app = xw.App(visible =False,add_book =False)
#books的子函数add用于新建工作簿
workbook =app.books.add()
#保存
workbook.save('D:\\pythonfile\list\example.xlsx')
#关闭并退出
workbook.close()
app.quit() 

#open excel.xlsx

import xlwings as xw
app = xw.App(visible =True,add_book =False)
workbook =app.books.open('D:\\pythonfile\list\example.xlsx') 

 #operate sheet and table

worksheet =workbook.sheets['Sheet1']
worksheet.range('A1').value ="编号"
#newadd one sheet and rename
worksheet =workbook.sheets.add('统计表')

#above all
import x