如何以编程方式编辑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?
我看过pyexcelerator
,xlrd
和xlwt
,但是它们似乎仅支持(据我所知)不支持编辑.我不能像使用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?