How to programmatically edit Excel sheets?

Question

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?

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?

Is this an xls or an xlsx file? – Shiraz Bhaiji Nov 19 '10 at 16:16 — Shiraz Bhaiji, Nov 19 '10 at 16:16

score 9 · Answer 1 · answered Nov 19 '10 at 16:10

First off, what version of Excel? Excel2007+ use an XML file format, while Excel2003- used a proprietary binary format... so the tools to read and write these work in totally different ways.

If you're after the more recent xlsx files, then take a look at Eric' Gazoni's openpyxl project. The code can be found on bitbucket. The driving force behind this is the ability to read and write xlsx files from Python within a single library.

Even then, it reads the entire workbook, but allows you to modify cells before writing it back.

Simply put: the structure of an Excel file doesn't lend itself to easy editing.... it's not simply a case of changing a few characters.

its an xls file that I need to edit. – Jim Jeffries Nov 19 '10 at 16:11 — Jim Jeffries, Nov 19 '10 at 16:11

score 2 · Accepted Answer · answered Nov 19 '10 at 16:07

2

xlutils has a copy module that may be interseting for you

answered Nov 19 '10 at 16:07

luc

41,928
25
127
172

score 0 · Answer 3 · answered Nov 19 '10 at 19:48

0

I have used pyexcelerator on linux to edit and build xls files

answered Nov 19 '10 at 19:48

Vince Spicer

4,325
3
21
11

How to programmatically edit Excel sheets?

3 Answers3

Linked