From: pp on 9 Jan 2010 03:30 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
From: Jason Scheirer on 9 Jan 2010 03:47 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
From: pp on 9 Jan 2010 03:58 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. Thanks.
From: Steve Holden on 9 Jan 2010 07:59 pp wrote: > 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. > 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 -- Steve Holden +1 571 484 6266 +1 800 494 3119 PyCon is coming! Atlanta, Feb 2010 http://us.pycon.org/ Holden Web LLC http://www.holdenweb.com/ UPCOMING EVENTS: http://holdenweb.eventbrite.com/
From: Niels L. Ellegaard on 9 Jan 2010 17:33 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 Niels
|
Next
|
Last
Pages: 1 2 Prev: Scripting (was Re: Python books, literature etc) Next: Porblem with xlutils/xlrd/xlwt |