pip install Spire.XLS

from spire.xls import *
from spire.xls.common import *

# 定義輸入輸出文件路徑
inputFile = "./Demos/Data/AddWorksheet.xlsx"
outputFile = "AddWorksheet.xlsx"

# 創(chuàng)建 Workbook 對象并加載文件
workbook = Workbook()
workbook.LoadFromFile(inputFile)

# 添加一個名為 AddedSheet 的新工作表
sheet = workbook.Worksheets.Add("AddedSheet")

# 在新工作表中寫入內(nèi)容
sheet.Range["C5"].Text = "This is a new sheet."

# 保存文件并釋放資源
workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls.common import *
from spire.xls import *

# 定義輸出文件路徑
outputFile = "CreateAnExcelWithFiveSheet.xlsx"

# 創(chuàng)建空的 Workbook 對象
workbook = Workbook()

# 創(chuàng)建 5 個空白工作表
workbook.CreateEmptySheets(5)

# 遍歷每個工作表，設(shè)置名稱并填充數(shù)據(jù)
for i in range(0, 5):
    sheet = workbook.Worksheets[i]
    sheet.Name = "Sheet" + str(i)
    
    # 在每個工作表中填充示例數(shù)據(jù)
    for row in range(1, 151):
        for col in range(1, 51):
            sheet.Range[row, col].Text = "row" + str(row) + " col" + str(col)

# 保存文件并釋放資源
workbook.SaveToFile(outputFile, ExcelVersion.Version2010)
workbook.Dispose()

from spire.xls import *
from spire.xls.common import *

# 定義輸入輸出文件路徑
inputFile = "./Demos/Data/RemoveWorksheet.xlsx"
outputFile = "RemoveWorksheet.xlsx"

# 創(chuàng)建 Workbook 對象并加載文件
workbook = Workbook()
workbook.LoadFromFile(inputFile)

# 通過索引刪除第二個工作表（索引從 0 開始）
workbook.Worksheets.RemoveAt(1)

# 保存文件并釋放資源
workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import *
from spire.xls.common import *

# 定義輸入輸出文件路徑
inputFile = "./Demos/Data/RemoveWorksheet.xlsx"
outputFile = "RemoveWorksheet_Conditional.xlsx"

# 創(chuàng)建 Workbook 對象并加載文件
workbook = Workbook()
workbook.LoadFromFile(inputFile)

# 收集需要刪除的工作表索引（從后往前遍歷，避免索引變化問題）
indexes_to_remove = []
for i in range(workbook.Worksheets.Count - 1, -1, -1):
    sheet = workbook.Worksheets[i]
    # 如果工作表名稱包含特定關(guān)鍵詞，則標(biāo)記為刪除
    if "臨時" in sheet.Name or "備份" in sheet.Name:
        indexes_to_remove.append(i)

# 執(zhí)行刪除操作
for index in indexes_to_remove:
    workbook.Worksheets.RemoveAt(index)

# 保存文件并釋放資源
workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import *
from spire.xls.common import *

def AppendAllText(fname: str, text: list):
    """輔助函數(shù)：將列表中的文本寫入文件"""
    fp = open(fname, "w", encoding="utf-8")
    for s in text:
        fp.write(s + "\n")
    fp.close()

# 定義輸入輸出文件路徑
inputFile = "./Demos/Data/WorksheetSample3.xlsx"
outputFile = "OutputGetWorksheetNames.txt"

# 創(chuàng)建 Workbook 對象并加載文件
workbook = Workbook()
workbook.LoadFromFile(inputFile)

# 獲取所有工作表的名稱
sb = []
for sheet in workbook.Worksheets:
    sb.append(sheet.Name)

# 將工作表名稱保存到文本文件
AppendAllText(outputFile, sb)

# 釋放資源
workbook.Dispose()

from spire.xls import *
from spire.xls.common import *

# 定義輸出文件路徑
outputFile = "DynamicWorksheetManagement.xlsx"

# 創(chuàng)建新的 Workbook 對象
workbook = Workbook()

# 假設(shè)我們有三個部門的數(shù)據(jù)需要分別放入不同的工作表
departments = ["銷售部", "市場部", "技術(shù)部"]

# 為每個部門創(chuàng)建一個工作表
for dept in departments:
    sheet = workbook.Worksheets.Add(dept)
    
    # 在每個工作表中添加標(biāo)題
    sheet.Range["A1"].Value = f"{dept} - 月度報告"
    sheet.Range["A1"].Style.Font.IsBold = True
    sheet.Range["A1"].Style.Font.Size = 14
    
    # 添加示例數(shù)據(jù)列標(biāo)題
    sheet.Range["A3"].Value = "項目名稱"
    sheet.Range["B3"].Value = "金額"
    sheet.Range["C3"].Value = "日期"
    
    # 設(shè)置列標(biāo)題樣式
    sheet.Range["A3:C3"].Style.Font.IsBold = True
    sheet.Range["A3:C3"].Style.Color = Color.LightGray

# 刪除默認(rèn)創(chuàng)建的空白工作表（如果有）
while workbook.Worksheets.Count > len(departments):
    workbook.Worksheets.RemoveAt(0)

# 保存文件并釋放資源
workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
workbook.Dispose()