【Python辦公自動化筆記-Excel篇3】練習一

from openpyxl import Workbook

path = "D:/sample.xlsx"

wb = Workbook()
for month in range(1, 13):
    wb.create_sheet(str(month) + "月")  
wb.remove(wb["Sheet"])  # 別忘了要刪除新建工作簿時自動建立的那張工作表

wb.save(path)

from openpyxl import load_workbook

path = 'D:/sample.xlsx'
wb = load_workbook(path)
wss = wb.worksheets
for ws in wss:
    ws.title = '竹科' + ws.title

# 將"竹科7月"工作表的標籤顏色更改為紅色
# ws7 = wb['竹科7月']
# ws7.sheet_properties.tabColor = "FF0000"

wb.save(path)