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

Neil Cerutti neilc at norwich.edu
Fri Sep 27 09:37:09 EDT 2013


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



More information about the Python-list mailing list