如何以编程方式编辑Excel工作表?

问题描述:

我需要使用python编辑Excel工作簿.有没有这样做的方法,而无需阅读工作簿,编辑我想要的内容并将其写回?即有没有一种方法可以即时进行,因为我只需要在每张纸上编辑几个值?

I need to edit an Excel workbook using python. Is there a way of doing this without reading in the workbook, editing what I want and the writing it back? i.e. is there a way I can do this on the fly, as I only need to edit a couple of values per sheet?

我看过pyexceleratorxlrdxlwt,但是它们似乎仅支持(据我所知)不支持编辑.我不能像使用Linux一样使用pywin32.

I have looked at pyexcelerator, xlrd, and xlwt, but they only seem to support (as far as I can work out) reading and writing not editing. I cannot use pywin32 as I am using linux.

有没有关于图书馆的建议或特定的做事方式?

Any suggestions of libraries or particular ways of doing things?

xlutils 有副本可能与您息息相关的模块

xlutils has a copy module that may be interseting for you