pip install Spire.XLS

from spire.xls import *

# 創(chuàng)建工作簿對(duì)象
workbook = Workbook()

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

# 在新工作表中寫入數(shù)據(jù)
sheet.Range["A1"].Text = "這是新添加的工作表"

# 保存文件
workbook.SaveToFile("AddWorksheet.xlsx", ExcelVersion.Version2013)
workbook.Dispose()

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("Template.xlsx")

# 獲取源工作表
sourceSheet = workbook.Worksheets[0]

# 創(chuàng)建目標(biāo)工作表
targetSheet = workbook.Worksheets.Add("CopyOfSource")

# 復(fù)制數(shù)據(jù)
sourceRange = sourceSheet.AllocatedRange
targetSheet.CopyFrom(sourceRange, targetSheet, targetSheet.FirstRow, targetSheet.FirstColumn, True)

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

from spire.xls import *

# 加載源文件
sourceWorkbook = Workbook()
sourceWorkbook.LoadFromFile("Source.xlsx")
srcSheet = sourceWorkbook.Worksheets[0]

# 加載目標(biāo)文件
targetWorkbook = Workbook()
targetWorkbook.LoadFromFile("Target.xlsx")

# 在目標(biāo)文件中添加新工作表并復(fù)制內(nèi)容
targetSheet = targetWorkbook.Worksheets.Add("ImportedSheet")
targetSheet.CopyFrom(srcSheet)

targetWorkbook.SaveToFile("CopyAcrossWorkbooks.xlsx", ExcelVersion.Version2013)
targetWorkbook.Dispose()
sourceWorkbook.Dispose()

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("MultiSheet.xlsx")

# 隱藏指定工作表
workbook.Worksheets["CalcSheet"].Visibility = WorksheetVisibility.Hidden

# 顯示被隱藏的工作表
workbook.Worksheets["Report"].Visibility = WorksheetVisibility.Visible

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

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("MultiSheet.xlsx")

# 獲取第一個(gè)工作表
sheet = workbook.Worksheets[0]

# 將其移動(dòng)到第 3 個(gè)位置（索引從 0 開始）
sheet.MoveWorksheet(2)

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

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("MultiSheet.xlsx")

# 通過索引刪除工作表
workbook.Worksheets.RemoveAt(1)

# 也可以通過名稱刪除
# workbook.Worksheets.Remove("TempSheet")

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

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("MultiSheet.xlsx")

# 為不同工作表設(shè)置標(biāo)簽顏色
workbook.Worksheets[0].TabColor = Color.get_Red()
workbook.Worksheets[1].TabColor = Color.get_Green()
workbook.Worksheets[2].TabColor = Color.get_LightBlue()

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

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("DataSheet.xlsx")

sheet = workbook.Worksheets[0]

# 凍結(jié)首行（第 2 行第 1 列以上的區(qū)域被凍結(jié)）
sheet.FreezePanes(2, 1)

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

from spire.xls import *

workbook = Workbook()
workbook.LoadFromFile("MultiSheet.xlsx")

# 遍歷并獲取所有工作表名稱
for sheet in workbook.Worksheets:
    print(sheet.Name)

workbook.Dispose()