pip install Spire.XLS

from spire.xls import *
from spire.xls.common import *
     
# 創(chuàng)建Workbook對(duì)象
workbook = Workbook()

# 獲取第一張工作表
sheet = workbook.Worksheets[0]

# 在指定單元格中插入圖片（此處為第一行第二列，即B1單元格）
picture = sheet.Pictures.Add(1, 2, "示例.png")

# 設(shè)置圖片寬高度
picture.Width = 120
picture.Height = 120

# 調(diào)整圖片所在位置的列寬和行高
sheet.Columns[1].ColumnWidth = 20
sheet.Rows[0].RowHeight = 110

# 設(shè)置單元格邊框與圖片之間的距離
picture.LeftColumnOffset = 90
picture.TopRowOffset = 20

# 保存文件
workbook.SaveToFile("插入圖片.xlsx", ExcelVersion.Version2016)
workbook.Dispose()

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

# 加載Excel文檔
workbook = Workbook()
workbook.LoadFromFile ("插入圖片.xlsx")

# 獲取第一張工作表
sheet = workbook.Worksheets[0]

# 獲取工作表中第一張圖片
excelPicture = sheet.Pictures[0]
            
# 替換圖片
excelPicture.Picture = Image.FromFile("pic.jpg")

# 保存文檔
workbook.SaveToFile("替換圖片.xlsx", ExcelVersion.Version2016)
workbook.Dispose()

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

# 加載Excel文檔
workbook = Workbook()
workbook.LoadFromFile("圖標(biāo).xlsx")

# 獲取第一張工作表
sheet = workbook.Worksheets[0]

# 獲取工作表中所有圖片
for i in range(sheet.Pictures.Count - 1, -1, -1):
    pic = sheet.Pictures[i]

    # 保存圖片
    pic.Picture.Save("提取圖片\\圖片-{0:d}.png".format(i), ImageFormat.get_Png())

workbook.Dispose()

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

# 加載Excel文檔
workbook = Workbook()
workbook.LoadFromFile("圖標(biāo).xlsx")

# 獲取第一張工作表
sheet = workbook.Worksheets[0]

# 刪除工作表中所有圖片
for i in range(sheet.Pictures.Count - 1, -1, -1):
    sheet.Pictures[i].Remove()

# 刪除指定圖片
# sheet.Pictures[imgIndex].Remove()

# 保存文檔
workbook.SaveToFile("刪除圖片.xlsx", ExcelVersion.Version2013)
workbook.Dispose()