Append to an Excel file

[Niels L. Ellegaard]

pp <parul.pandey85 at gmail.com> writes:

> On Jan 9, 1:47 am, Jason Scheirer <jason.schei... at gmail.com> wrote:
>> On Jan 9, 12:30 am, pp <parul.pande... at gmail.com> 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
>>
>> http://pypi.python.org/pypi/xlwt
>
> 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

https://secure.simplistix.co.uk/svn/xlutils/trunk/xlutils/docs/copy.txt

      Niels