python - 有没有办法在 Python 中编辑包含图像的 xlsx 工作簿？

Question

有没有一种方法可以通过 Python 编辑和保存包含图像、图表、图形等的 xlsx-workbook？

我尝试过的一些事情:

• > openpyxl :

  openpyxl does currently not read all possible items in an Excel file so images and charts will be lost from existing files if they are opened and saved with the same name.

• > xlwt :

  xlwt is a library for writing data and formatting information to older Excel files (ie: .xls)

• > xlutils :

  Utilities for working with Excel files that require both xlrd and xlwt

<子> Related.

Answer 1

XLWings 模块似乎是唯一支持此功能的模块: http://docs.xlwings.org/en/stable/quickstart.html .与其他 Python/Excel 模块不同，它似乎在后台使用 COM 自动化来连接到 Excel。

import xlwings as xw
wb = xw.Book()  # this will create a new workbook
wb = xw.Book('FileName.xlsx')  # connect to an existing file in the current working directory
wb = xw.Book(r'C:\path\to\file.xlsx')  # on Windows: use raw strings to escape backslashes
app = xw.App()  # or something like xw.apps[0] for existing apps
wb = app.books['Book1']