From: Chris Withers on 12 Jan 2010 03:14
Niels L. Ellegaard wrote:
> pp <parul.pandey85(a)gmail.com> writes:
>> On Jan 9, 1:47 am, Jason Scheirer <jason.schei...(a)gmail.com> wrote:
>>> On Jan 9, 12:30 am, pp <parul.pande...(a)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.
>> Hi Jason and all,
>> 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
Yup, that's the one...
Oh to have funded time to turn all the docs for xl(rd|wt|utils) into
nice Sphinx docs...
Simplistix - Content Management, Batch Processing & Python Consulting