Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #54884
| References | <276eb8a6-f326-412f-accf-53bb4677c8c7@googlegroups.com> <balg05Fu9ngU1@mid.individual.net> |
|---|---|
| Date | 2013-09-27 10:13 -0400 |
| Subject | Re: How to write in to already opened excel file by using openpyxl |
| From | Joel Goldstick <joel.goldstick@gmail.com> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.383.1380291227.18130.python-list@python.org> (permalink) |
[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
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