Python-Excel-05-居中设置及字体设置

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")
xl_app = win32com.client.gencache.EnsureDispatch("Excel.Application")  # 若想引用常数的话使用此法调用Excel

xl_app.Visible = False  # 是否显示Excel文件

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

# 居中对齐，字体设置
rng_cells = sht.Cells
rng_cells.HorizontalAlignment = c.xlCenter
rng_cells.VerticalAlignment = c.xlCenter
rng_cells.Orientation = 0
rng_cells.AddIndent = False
rng_cells.IndentLevel = 0
rng_cells.ShrinkToFit = False
rng_cells.ReadingOrder = c.xlContext
rng_cells.Font.Size = 16

rng_cells.Font.Name = "黑体"
rng_cells.Font.Name = "Arial"

wb.Save()
wb.Close()