Append to an Excel file

Niels L. Ellegaard niels.ellegaard at
Sat Jan 9 23:33:28 CET 2010

pp <parul.pandey85 at> writes:

> On Jan 9, 1:47 am, Jason Scheirer <jason.schei... at> wrote:
>> On Jan 9, 12:30 am, pp <parul.pande... at> wrote:
>> > Hi All,
>> > How do I add a line to an existing file. This should append to the
>> > existing data in the excel file, which was saved previously.
>> > Thanks,
>> > PP
> Hi Jason and all,
> Thanks
> I have seen this.. my question is there a  way to append to a excel
> file which has been closed. Any specific modes which can be added to
> the sheet so that it adds a line to the data which was return in some
> earlier running of the program.

I may be wrong, but I think that you have to do the following

1) Use xlrd to read the file. This creates an xlrd.Book
2) Use xlutils to transform the xlrd.Book into a xlwt.WorkBook
3) Edit the xlwt.WorkBook
4) Save the xlwt.WorkBook


More information about the Python-list mailing list