Home Original page

Append to an Excel file

Chris Withers chris at simplistix.co.uk
Tue Jan 12 03:14:20 EST 2010 
Niels L. Ellegaard wrote:
> 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

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
More information about the Python-list mailing list