How to write in to already opened excel file by using openpyxl

[Joel Goldstick]

On Fri, Sep 27, 2013 at 9:37 AM, Neil Cerutti <neilc at norwich.edu> wrote:

> On 2013-09-27, someshg2 at gmail.com <someshg2 at gmail.com> wrote:
> > Hi..there,
> >
> > I have opened a excel file by using the following code
> > from openpyxl import load_workbook
> >
> >  wb = load_workbook('path of the file')
> >     DriverTableSheet = wb.get_sheet_by_name(name = 'name of the sheet')
> > after that i have to append some values in that excel file..
> >
> > for that i used the following code
> >
> > DriverTableSheet.cell(row=1, column=2).value="value"
> >
> > but it is not responsive..can u guys please guide how to write
> > / append a data in that excel file and save that excel file<https://mail.python.org/mailman/listinfo/python-list>
>


> https://mail.python.org/mailman/listinfo/python-list
>

You need to read the documentation:
http://openpyxl.readthedocs.org/en/latest/tutorial.html#saving-to-a-file

The code you show doesn't have any save method being called.


-- 
Joel Goldstick
http://joelgoldstick.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20130927/d894253b/attachment.html>