pip install spire.xls.free

from spire.xls import Workbook
# 創(chuàng)建一個新的工作簿
wb = Workbook()
sheet = wb.Worksheets[0]
sheet.Name = "項目進度表"
# 保存初始文件
wb.SaveToFile("ProjectProgress.xlsx")
wb.Dispose()
print("Excel 文件已創(chuàng)建：ProjectProgress.xlsx")

from spire.xls import Workbook

wb = Workbook()
sheet = wb.Worksheets[0]
sheet.Name = "項目進度表"

# 寫入表頭
headers = ["任務名稱", "負責人", "完成進度", "備注"]
for col, header in enumerate(headers, start=1):
    sheet.Range[1, col].Text = header

# 寫入示例數據
project_data = [
    ["需求分析", "張三", "100%"],
    ["系統(tǒng)設計", "李四", "80%"],
    ["前端開發(fā)", "王五", "60%"],
    ["后端開發(fā)", "趙六", "45%"],
    ["測試驗收", "孫七", "20%"],
]

for row, data in enumerate(project_data, start=2):
    for col, value in enumerate(data, start=1):
        sheet.Range[row, col].Value = value

# 自動調整列寬
sheet.Range.AutoFitColumns()

wb.SaveToFile("ProjectProgress.xlsx")
wb.Dispose()
print("項目數據已寫入 Excel 文件")

from spire.xls import Workbook

wb = Workbook()
wb.LoadFromFile("ProjectProgress.xlsx")
sheet = wb.Worksheets[0]

# 為"后端開發(fā)"單元格添加批注
range_comment = sheet.Range["A5"]
comment = range_comment.AddComment()
comment.Text = "后端開發(fā)進度較慢，主要原因是接口文檔不完善，需要補充API說明。"
comment.Width = 200
comment.Visible = True

wb.SaveToFile("ProjectProgress_AddComment.xlsx")
wb.Dispose()
print("批注已添加")

from spire.xls import Workbook, ExcelColors

wb = Workbook()
wb.LoadFromFile("ProjectProgress_AddComment.xlsx")
sheet = wb.Worksheets[0]

# 為"測試驗收"單元格添加帶作者的批注
range_comment = sheet.Range["A6"]
author = "項目經理：周八"
text = "測試用例覆蓋率不足，建議補充邊界測試和異常場景測試。"

comment = range_comment.AddComment()
comment.Text = author + ":\n" + text
comment.Width = 250
comment.Visible = True

# 設置作者部分的字體樣式
font = wb.CreateFont()
font.FontName = "Tahoma"
font.KnownColor = ExcelColors.Black
font.IsBold = True
comment.RichText.SetFont(0, len(author), font)

wb.SaveToFile("ProjectProgress_CommentWithAuthor.xlsx")
wb.Dispose()
print("帶作者的批注已添加")

from spire.xls import Workbook

wb = Workbook()
wb.LoadFromFile("ProjectProgress_CommentWithAuthor.xlsx")
sheet = wb.Worksheets[0]

# 獲取第一個批注并編輯
comment = sheet.Comments[0]
comment.Text = "后端開發(fā)進度已提升至60%，接口文檔已完善，開發(fā)工作正常推進。"

wb.SaveToFile("ProjectProgress_EditComment.xlsx")
wb.Dispose()
print("批注已編輯")

from spire.xls import Workbook

wb = Workbook()
wb.LoadFromFile("ProjectProgress_EditComment.xlsx")
sheet = wb.Worksheets[0]

# 獲取所有批注
comments = sheet.Comments

# 刪除第一個批注
if comments.Count > 0:
    comments[0].Remove()
    print("批注已刪除")

wb.SaveToFile("ProjectProgress_RemoveComment.xlsx")
wb.Dispose()

from spire.xls import Workbook

wb = Workbook()
wb.LoadFromFile("ProjectProgress_CommentWithAuthor.xlsx")
sheet = wb.Worksheets[0]

# 讀取所有批注
comments = sheet.Comments
print(f"工作表中共有 {comments.Count} 條批注：\n")

for i in range(comments.Count):
    comment = comments[i]
    print(f"批注 {i+1}：")
    print(f"  內容：{comment.Text}")
    print(f"  位置：{comment.Range.RangeAddressLocal}\n")

wb.Dispose()