Python Forum

Full Version: Want to add formula to excel sheet
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
good evening,

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