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

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<joel.goldstick@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.035
X-Spam-Evidence	'H': 0.93; 'S': 0.00; 'subject:file': 0.07; 'append': 0.09; 'subject:using': 0.09; 'subject:How': 0.10; 'cc:addr:python-list': 0.11; 'called.': 0.16; 'subject:already': 0.16; 'wrote:': 0.18; 'import': 0.22; 'email addr:gmail.com>': 0.22; 'cc:addr:python.org': 0.22; 'guys': 0.24; 'cc:2**0': 0.24; '>': 0.26; 'excel': 0.26; 'values': 0.27; 'header:In-Reply- To:1': 0.27; 'am,': 0.29; "doesn't": 0.30; 'message- id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'code': 0.31; 'sep': 0.31; 'file': 0.32; 'skip:c 30': 0.32; 'url:python': 0.33; 'fri,': 0.33; 'skip:d 20': 0.34; 'but': 0.35; 'received:google.com': 0.35; 'url:listinfo': 0.36; 'method': 0.36; 'url:org': 0.36; 'being': 0.38; 'url:mail': 0.40; 'how': 0.40; 'read': 0.60; 'save': 0.62; 'email addr:gmail.com': 0.63; 'show': 0.63; 'joel': 0.91; 'url:latest': 0.91; '2013': 0.98
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=zYiL3W7q4x9VlzLItbL7hs2lYT0dRuESU/TjJCWWPqI=; b=i16DNKoU1OEDU5UEqDRGKTIqKEq412eZAUVQc4dvj7HVPqtDKTwP/U2QktPkUAUF1a w2e7tYSffJEYzFniWDFttK65X9mNjEYq8Wm+dtxSb/F6ksCBRsowyCYmuBF4JmUbWG0x UxGphh0wzc9wfu3VR33fjqg0T+L3Zk+cBn9t2yvxsWBUN1p0YS8rx6jQ4D6u3WVjMobh TPjl+dbQyQE4PUNa+ptbk2E5AxUOcFzF5EGo2yeo8SZAkQnKVVqdNrpMA/fXQ0qIY6x3 c/0SdziwKyBkiUb0+8vwK4At90uy/9EWLmaj0VKABBsX3sCahRo2Rhu5wRTSLTpSrF0S uubA==
MIME-Version	1.0
X-Received	by 10.58.28.147 with SMTP id b19mr1862612veh.27.1380291218011; Fri, 27 Sep 2013 07:13:38 -0700 (PDT)
In-Reply-To	<balg05Fu9ngU1@mid.individual.net>
References	<276eb8a6-f326-412f-accf-53bb4677c8c7@googlegroups.com> <balg05Fu9ngU1@mid.individual.net>
Date	Fri, 27 Sep 2013 10:13:37 -0400
Subject	Re: How to write in to already opened excel file by using openpyxl
From	Joel Goldstick <joel.goldstick@gmail.com>
To	Neil Cerutti <neilc@norwich.edu>
Content-Type	multipart/alternative; boundary=047d7b6d7db2bcac7204e75e1744
Cc	"python-list@python.org" <python-list@python.org>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.383.1380291227.18130.python-list@python.org> (permalink)
Lines	88
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1380291227 news.xs4all.nl 15993 [2001:888:2000:d::a6]:37909
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:54884

Show key headers only | View raw

[Multipart message — attachments visible in raw view] - view raw

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

> On 2013-09-27, someshg2@gmail.com <someshg2@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

Thread

How to write in to already opened excel file by using openpyxl someshg2@gmail.com - 2013-09-27 05:48 -0700
  Re: How to write in to already opened excel file by using openpyxl Neil Cerutti <neilc@norwich.edu> - 2013-09-27 13:37 +0000
    Re: How to write in to already opened excel file by using openpyxl Joel Goldstick <joel.goldstick@gmail.com> - 2013-09-27 10:13 -0400
  Re: How to write in to already opened excel file by using openpyxl somesh g <someshg2@gmail.com> - 2013-09-27 07:33 -0700
  Re: How to write in to already opened excel file by using openpyxl somesh g <someshg2@gmail.com> - 2013-09-27 07:33 -0700

csiph-web