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

Newsgroups	comp.lang.python
Date	2013-09-27 05:48 -0700
Message-ID	<276eb8a6-f326-412f-accf-53bb4677c8c7@googlegroups.com> (permalink)
Subject	How to write in to already opened excel file by using openpyxl
From	someshg2@gmail.com

Show all headers | View raw

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

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

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