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


S

someshg2

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
 
Ad

Advertisements

N

Neil Cerutti

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?
 
S

somesh g

hi..Neil

yes i dint saved that time and i added the save option and it saved

Thanks for the response
 
Ad

Advertisements

S

somesh g

Hi..joel

what is said is correct i dint added save to that after adding its working perfect

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top