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 Niels -- http://mail.python.org/mailman/listinfo/python-list