用Python在Excel中嵌入附件(txt文件、zip包)对象,使用,压缩包
发表时间:2020-07-04
首先,本代码已调试通过,环境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&