Python和openpyxl将我的共享工作簿保存为未共享 [英] Python and openpyxl is saving my shared workbook as unshared

问题描述

使用Python和openpyxl，我有一个进入工作簿的代码，每天向一些单元格中添加一堆信息，然后关闭并保存它.我的问题是，如果打开此工作簿，则代码将不起作用(显然).

Using Python and openpyxl I have a code that goes into a workbook, adds a bunch of information to some cells every day, and then closes and saves it. My problem is that if this workbook is open the code doesn't work (obviously).

通过使工作簿共享(多个用户可以一次编辑)，我可以解决此问题，但是在代码运行一次之后，python保存，然后将其恢复为封闭的，未共享的工作簿. 有人知道openpyxl是否可以另存为共享文件吗?我在网上找不到任何东西. 先发制人的感谢您的帮助.

By making the workbook shared(multiple users can edit at once) I can overcome this problem, however after the code runs once, python saves and then reverts it back to a closed, unshared workbook. Anyone know if openpyxl can save as shared? I'm not finding anything online. Pre-emptive thanks for your help.

推荐答案

似乎openpyxl保存Excel工作簿时，内部的docProps/app.xml文件将被擦除并且仅包含最少的信息.

It seems that when openpyxl saves an Excel workbook, the docProps/app.xml file inside is wiped and contains only minimal information.

一种快速(又肮脏)的解决方案是使用zipfile获取这些信息并将其传输到新的/保存的文件中.

A quick (and dirty) solution is to use zipfile to get these information and transfer them into the new/saved file.

import zipfile, openpyxl

def shared_pyxl_save(file_path, workbook):
    """
    `file_path`: path to the shared file you want to save
    `workbook`: the object returned by openpyxl.load_workbook()
    """
    zin = zipfile.ZipFile(file_path, 'r')
    buffers = []
    for item in zin.infolist():
        buffers.append((item, zin.read(item.filename)))
    zin.close()

    workbook.save(file_path)

    zout = zipfile.ZipFile(file_path, 'w')
    for item, buffer in buffers:
        zout.writestr(item, buffer)
    zout.close()

这篇关于Python和openpyxl将我的共享工作簿保存为未共享的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！