Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #54882
| 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 <neilc@norwich.edu> |
| 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 | <balg05Fu9ngU1@mid.individual.net> (permalink) |
| 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 |
Show key headers only | View raw
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
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
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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