How do I insert a value in Excel using python

Question

a very straightforward task in VBA but am not sure how do I perform in python. Hypothetically if I have an excel called 'excel.xlsm', tab name is 'tabA' and I want to insert a value in cell D15, how do I do that in python?

This question has a lot of answers if searched on Google. Please do some research before asking on SO community. — Abhay Salvi
– Abhay Salvi, Commented Apr 20, 2020 at 13:36
Does this answer your question? Insert row into Excel spreadsheet using openpyxl in Python — Mayank Porwal
– Mayank Porwal, Commented Apr 20, 2020 at 13:37
@Abhay salvi - never heard of google, can you send me the link plz! — TRex
– TRex, Commented Apr 20, 2020 at 14:01

Tomfus · Accepted Answer · 2020-04-20 13:32:38Z

3

You need a library called openpyxl for that:

import openpyxl

workbook=openpyxls.load_workbook(path)
worksheet= workbook.get_sheet_by_name('tabA')
worksheet['D15']='Whatever you want to put in D15'

Enjoy and read up on openpyxl for more info.

answered Apr 20, 2020 at 13:32

Tomfus

834 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

livan3li · Accepted Answer · 2024-01-09 09:28:01Z

0

I couldn't edit Tomfus's answer. To save you excel file after changes you made (otherwise you won't see updates in file). Run workbook.save('file path of your excel')

NOT: File path could be same file path/name that you used to open if you don't want to create copy. It will overwrite automatically

answered Jan 9, 2024 at 9:28

livan3li

1,0781 gold badge10 silver badges21 bronze badges

Collectives™ on Stack Overflow

How do I insert a value in Excel using python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related