Prev: Scripting (was Re: Python books, literature etc)
Next: Porblem with xlutils/xlrd/xlwt
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.
>>>> 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

First  |  Prev  | 
Pages: 1 2
Prev: Scripting (was Re: Python books, literature etc)
Next: Porblem with xlutils/xlrd/xlwt