Niels L. Ellegaard wrote:
pp <parul.pande...@gmail.com> writes:

On Jan 9, 1:47 am, Jason Scheirer <jason.schei...@gmail.com> wrote:
On Jan 9, 12:30 am, pp <parul.pande...@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

Yup, that's the one...

Oh to have funded time to turn all the docs for xl(rd|wt|utils) into nice Sphinx docs...

Chris

--
Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk

--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to