用Python编辑Excel表格 [英] Editing Excel sheets with Python

问题描述

我需要使用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? ie 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，但他们似乎只是支持（据我所知），读写不会编辑。我不能使用pywin32，因为我正在使用linux。

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

这篇关于用Python编辑Excel表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！