Want to add formula to excel sheet

Want to add formula to excel sheet - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Want to add formula to excel sheet (/thread-23359.html)

Want to add formula to excel sheet - nagu4651 - Dec-24-2019

Hi Team,

I just want to add two columns in excel sheet leaving first row and adding (ab+ac=AD) for all rows except first row . How can I proceed ahead , below is the sample code I have developed . Please help me with this

import openpyxl
path="C:\\Users\\j.kumar\\test.xlsx"
wb=openpyxl.load_workbook(path,data_only=True)
print(wb.sheetnames)
sheet=wb["report_on_ora_strg_req_db"]

Thanks & regards,
Kumar

RE: Want to add formula to excel sheet - keuninkske - Dec-26-2019

good evening,

please querry google or youtube for 'openpyxl python tutorial' and you will find an answer to alot of your questions