Python-Excel-07-新建Excel工作簿

import os
import win32com
from win32com.client import constants as c  # 旨在直接使用VBA常数

current_address = os.path.abspath('.')excel_address = os.path.join(current_address, "新建.xlsx")
if os.path.exists(excel_address):
   os.remove(excel_address)xl_app = win32com.client.gencache.EnsureDispatch("Excel.Application")  # 若想引用常数的话使用此法调用Excel
xl_app.Visible = True  # 是否显示Excel文件

wb = xl_app.Workbooks.Add()
wb.SaveAs(excel_address)sht = wb.Worksheets(1)
sht.Name = "示例"

sht.Range("A1").Value = "测试"

wb.Save()
wb.Close()
xl_app.Quit()