pip install spire.xls

from spire.xls import Workbook, ExcelVersion

workbook.LoadFromFile("data.xlsx")

workbook.LoadFromFile(r"C:\Users\Administrator\Desktop\data.xlsx")

workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013)

from spire.xls import Workbook, ExcelVersion

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 在C1單元格添加批注
cell = sheet.Range["C1"]
comment = cell.AddComment()
comment.Text = "這是簡單的批注內(nèi)容"

# 默認批注是隱藏的，鼠標懸停才顯示
# 如果想一直顯示：
comment.Visible = True

workbook.SaveToFile("simple_comment.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion

workbook = Workbook()
workbook.LoadFromFile("data.xlsx")
sheet = workbook.Worksheets[0]

# 獲取要添加批注的單元格
cell = sheet.Range["C1"]

# 設(shè)置作者和內(nèi)容
author = "張三"
text = "這個數(shù)據(jù)需要進一步核實"

comment = cell.AddComment()
comment.Width = 200
comment.Visible = True

# 格式：作者 + 換行 + 內(nèi)容
comment.Text = f"{author}:\n{text}"

# 讓作者名字加粗顯示
font = workbook.CreateFont()
font.FontName = "Tahoma"
font.IsBold = True
comment.RichText.SetFont(0, len(author), font)

workbook.SaveToFile("comment_with_author.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion

workbook = Workbook()
workbook.LoadFromFile("template.xlsx")
sheet = workbook.Worksheets[0]

# 創(chuàng)建不同顏色的字體
font_orange = workbook.CreateFont()
font_orange.FontName = "Arial"
font_orange.Size = 11
font_orange.KnownColor = ExcelColors.Orange

font_blue = workbook.CreateFont()
font_blue.KnownColor = ExcelColors.LightBlue

font_green = workbook.CreateFont()
font_green.KnownColor = ExcelColors.LightGreen

# 添加批注并設(shè)置富文本
cell = sheet.Range["B12"]
comment = cell.Comment

comment.RichText.Text = "注意：此數(shù)據(jù)已審核通過"

# 前4個字用綠色（"注意："）
comment.RichText.SetFont(0, 4, font_green)

# 后面的字用藍色
comment.RichText.SetFont(5, 12, font_blue)

workbook.SaveToFile("rich_text_comment.xlsx", ExcelVersion.Version2007)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion, Color

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 創(chuàng)建多種字體樣式
font_title = workbook.CreateFont()
font_title.FontName = "Calibri"
font_title.Color = Color.get_Firebrick()  # 深紅色
font_title.IsBold = True
font_title.Size = 12

font_body = workbook.CreateFont()
font_body.FontName = "Calibri"
font_body.Color = Color.get_Blue()
font_body.Size = 12

# 添加詳細批注
cell = sheet.Range["G5"]
comment = cell.Comment
comment.IsVisible = True
comment.Height = 150
comment.Width = 300

comment.RichText.Text = "產(chǎn)品說明：\nSpire.XLS是一個獨立的Excel組件，支持轉(zhuǎn)換、數(shù)據(jù)處理、圖表等功能。"

# 標題部分加粗紅色
comment.RichText.SetFont(0, 4, font_title)

# 正文部分藍色
comment.RichText.SetFont(5, 50, font_body)

workbook.SaveToFile("formatted_comment.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook

workbook = Workbook()
workbook.LoadFromFile("with_comments.xlsx")
sheet = workbook.Worksheets[0]

# 讀取A1單元格的批注
comment_text = sheet.Range["A1"].Comment.Text
print(f"批注內(nèi)容：{comment_text}")

# 如果批注有富文本，可以獲取RTF格式
rich_text = sheet.Range["A2"].Comment.RichText.RtfText
print(f"富文本格式：{rich_text}")

workbook.Dispose()

from spire.xls import Workbook

workbook = Workbook()
workbook.LoadFromFile("reviewed_data.xlsx")
sheet = workbook.Worksheets[0]

# 遍歷所有有批注的單元格
comments_info = []

for row in range(1, sheet.AllocatedRange.RowCount + 1):
    for col in range(1, sheet.AllocatedRange.ColumnCount + 1):
        cell = sheet.Range[row, col]
        
        if cell.Comment is not None:
            info = {
                'cell': f"{chr(64+col)}{row}",  # 如 "A1"
                'author': cell.Comment.Text.split(':')[0] if ':' in cell.Comment.Text else '',
                'content': cell.Comment.Text,
                'visible': cell.Comment.Visible
            }
            comments_info.append(info)

# 輸出所有批注信息
for info in comments_info:
    print(f"單元格 {info['cell']}: {info['content']}")

workbook.Dispose()

from spire.xls import Workbook, ExcelVersion

workbook = Workbook()
workbook.LoadFromFile("existing_comments.xlsx")
sheet = workbook.Worksheets[0]

# 方式1：直接修改第一個批注
comment = sheet.Comments[0]
comment.Text = "批注內(nèi)容已更新 - 2024年審核"

# 方式2：修改特定單元格的批注
sheet.Range["B5"].Comment.Text = "數(shù)據(jù)已修正"

workbook.SaveToFile("updated_comments.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion

workbook = Workbook()
workbook.LoadFromFile("with_comments.xlsx")
sheet = workbook.Worksheets[0]

# 方式1：刪除特定批注
comments = sheet.Comments
if comments.Count > 0:
    comments[1].Remove()  # 刪除第二個批注

# 方式2：刪除所有批注
while sheet.Comments.Count > 0:
    sheet.Comments[0].Remove()

workbook.SaveToFile("no_comments.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion, CommentVAlignType, CommentHAlignType

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 添加批注
cell = sheet.Range["G5"]
cell.Text = "查看批注"
comment = cell.Comment

comment.IsVisible = True
comment.Height = 150  # 高度
comment.Width = 300   # 寬度

# 設(shè)置絕對位置（相對于工作表左上角）
comment.Top = 20   # 距離頂部20像素
comment.Left = 40  # 距離左側(cè)40像素

# 設(shè)置文本對齊方式
comment.VAlignment = CommentVAlignType.Center  # 垂直居中
comment.HAlignment = CommentHAlignType.Justified  # 水平兩端對齊

comment.RichText.Text = "這是一個精確定位的批注，\n可以控制大小、位置和對齊方式。"

workbook.SaveToFile("positioned_comment.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion
from System.IO import FileStream, FileMode

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 在單元格添加文本
cell = sheet.Range["C6"]
cell.Text = "公司Logo"

# 添加批注
comment = cell.AddComment()

# 加載圖片作為背景
image_stream = FileStream("logo.png", FileMode.Open)
comment.Fill.CustomPicture(image_stream, "logo.png")

comment.Visible = True

workbook.SaveToFile("comment_with_image.xlsx", ExcelVersion.Version2010)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion, TextRotationType

workbook = Workbook()
sheet = workbook.Worksheets[0]

cell = sheet.Range["D10"]
comment = cell.AddComment()

comment.Text = "這段文字可以旋轉(zhuǎn)顯示"
comment.TextRotation = TextRotationType.LeftToRight  # 從左到右

# 其他選項：
# TextRotationType.RightToLeft  # 從右到左
# TextRotationType.TopToBottom  # 從上到下

comment.Visible = True

workbook.SaveToFile("rotated_comment.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion

workbook = Workbook()
workbook.LoadFromFile("with_comments.xlsx")
sheet = workbook.Worksheets[0]

# 顯示所有批注
for comment in sheet.Comments:
    comment.Visible = True

# 或者只顯示特定的批注
sheet.Range["A1"].Comment.Visible = True
sheet.Range["B2"].Comment.Visible = False  # 隱藏這個

workbook.SaveToFile("visibility_control.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import Workbook, ExcelVersion, Color
import csv

def create_review_report(csv_file: str, output_file: str):
    """
    從CSV創(chuàng)建Excel報表，自動添加審核批注
    """
    
    workbook = Workbook()
    sheet = workbook.Worksheets[0]
    sheet.Name = "銷售數(shù)據(jù)審核"
    
    # 創(chuàng)建字體樣式
    font_warning = workbook.CreateFont()
    font_warning.Color = Color.get_Red()
    font_warning.IsBold = True
    
    font_info = workbook.CreateFont()
    font_info.Color = Color.get_Blue()
    
    # 讀取CSV數(shù)據(jù)
    with open(csv_file, 'r', encoding='utf-8') as f:
        reader = csv.reader(f)
        headers = next(reader)
        
        # 寫入表頭
        for col, header in enumerate(headers, 1):
            sheet.Range[1, col].Value = header
        
        # 寫入數(shù)據(jù)并檢查異常
        row_num = 2
        for row in reader:
            for col, value in enumerate(row, 1):
                sheet.Range[row_num, col].Value = value
            
            # 假設(shè)第3列是銷售額，檢查異常值
            try:
                sales = float(row[2])
                
                # 銷售額超過10000，添加警告批注
                if sales > 10000:
                    cell = sheet.Range[row_num, 3]
                    comment = cell.AddComment()
                    
                    comment.Text = f"警告：銷售額 {sales:.2f} 超出正常范圍\n請核實數(shù)據(jù)準確性"
                    comment.Width = 250
                    comment.Visible = True
                    
                    # 設(shè)置警告樣式
                    comment.RichText.SetFont(0, 2, font_warning)
                    comment.RichText.SetFont(3, len(comment.Text), font_info)
                    
                    # 高亮單元格
                    cell.Style.Color = Color.get_LightYellow()
                    
            except (ValueError, IndexError):
                pass
            
            row_num += 1
    
    # 自動調(diào)整列寬
    sheet.AllocatedRange.AutoFitColumns()
    
    # 添加說明批注
    title_cell = sheet.Range["A1"]
    title_comment = title_cell.AddComment()
    title_comment.Text = "審核說明：\n- 紅色批注：數(shù)據(jù)異常需核實\n- 黃色背景：已標記的高值\n- 請審核后移除此批注"
    title_comment.Width = 300
    title_comment.Height = 150
    title_comment.Visible = True
    
    workbook.SaveToFile(output_file, ExcelVersion.Version2013)
    workbook.Dispose()
    
    print(f"審核報表已生成：{output_file}")

# 使用示例
create_review_report("sales_data.csv", "sales_review.xlsx")

comments_export = []
for row in range(1, max_row + 1):
    for col in range(1, max_col + 1):
        cell = sheet.Range[row, col]
        if cell.Comment:
            comments_export.append({
                'location': f"{chr(64+col)}{row}",
                'text': cell.Comment.Text
            })

# 保存到CSV或數(shù)據(jù)庫