Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Neil Cerutti Newsgroups: comp.lang.python Subject: Re: How to write in to already opened excel file by using openpyxl Date: 27 Sep 2013 13:37:09 GMT Organization: Norwich University Lines: 24 Message-ID: References: <276eb8a6-f326-412f-accf-53bb4677c8c7@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: individual.net FZe0Su0dT6MCzO0pa3Cx4w3PjEGGWPy67lsoZFI6Gtc4hAl8cb Cancel-Lock: sha1:ip9vgKOFKSYITYBPw+wvXzTvw0w= User-Agent: slrn/0.9.9p1/mm/ao (Win32) Xref: csiph.com comp.lang.python:54882 On 2013-09-27, 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 Show more code, please. And please describe the error more fully. What did you hope to happen, and what happened instead? What have you tried so far? -- Neil Cerutti