Append to an Excel file

[pp]

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

 

[Jason Scheirer]

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

 

[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.


Thanks.

 

[Steve Holden]

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.

If you are talking about an XLS file and not a CSV then it's a highly
structured object, and you can't just "stick bits on the end" with any
expectation that Excel will know what to do with the new data. The most
likely outcomes would be Excel either complaining the file format is
invalid or ignoring the extra data.

If it's a CSV file, then f = open(file, "a") should do it.

regards
Steve

 

[Niels L. Ellegaard]

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

 

[Chris Withers]

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