文章原创，如有转载，请注明出处。
首先，本代码已调试通过，环境Windows10,python3.8
pip install pywin32(注意：它自动安装你Python对应的版本，目前一些网址上可以下载的pywin32只到python3.6)
打开已有的CrisBook.xlsx文件，sheet页:'Operational Status Of SITE'，自己要改成对应自己需要的sheet页名称
import win32com.client
if __name__ == "__main__":
filename = "C:\Work_folder\python\CrisBook.xlsx"
xlApp = win32com.client.Dispatch('Excel.Application')
xlApp.Visible = 1
workbook = xlApp.Workbooks.Open(r'C:\Work_folder\python\CrisBook.xlsx')
worksheet = workbook.Sheets('Operational Status Of SITE')
worksheet.Cells(7, 1).Value = 'title'
worksheet.Cells(7, 2).Value = '123'
# To assign an object for OLEObject(=EMBED("Packager Shell Object","")).
Embedded_object = worksheet.OLEObjects()
# To assign location of the image file that need to inserted as OBJECT in excel worksheet.
file_location = "C:\Work_folder\python\Diag_add_supp.txt"
file_location1 = "C:\Work_folder\python\Diag_add_supp.zip"
# To add selected file to the excel worksheet. It will add the OBJECT to the A1 cell of the current worksheet.
Embedded_object.Add(ClassType=None, Filename=file_location, Link=False, DisplayAsIcon=True, Width=18, Height=50)
Embedded_object.Add(ClassType=None, Filename=file_location1, Link=False, DisplayAsIcon=True, Width=18, Height=50)
# 必须重新赋值一次，否则Embedded_object.Count一直等于0
Embedded_object = worksheet.OLEObjects()
print(Embedded_object.Count)
for i in range(1, (Embedded_object.Count + 1)):
obj = Embedded_object.Item(i)
obj.Left = worksheet.Cells(10, 5).left + (i-1)*90
obj.Top = worksheet.Cells(10, 5).Top
worksheet.Rows(10).RowHeight = 50
worksheet.Columns(5).ColumnWidth = 40
Processed:
0.009, SQL:
9
