Python Forum
Want to add formula to excel sheet
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Want to add formula to excel sheet
#1
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
Reply
#2
good evening,

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


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 1,696 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Help using a dynamic array excel formula with XLWings FXMonkey 2 1,209 Jun-06-2023, 09:46 PM
Last Post: FXMonkey
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,515 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Openpyxl manipulate excel write formula SamLiu 0 1,002 Nov-04-2022, 03:00 PM
Last Post: SamLiu
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 6,857 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  {SOLVED]Help getting formula value in Excel to a csv Pedroski55 1 1,971 Sep-20-2021, 12:19 AM
Last Post: Pedroski55
  Python “Formula” Package: How do I parse Excel formula with a range of cells? JaneTan 1 2,640 Jul-12-2021, 11:09 AM
Last Post: jefsummers
  How do I read in a Formula in Excel and convert it to do the computation in Python? JaneTan 2 2,562 Jul-07-2021, 02:06 PM
Last Post: Marbelous
  Python script for excel sheet Nabil 4 3,224 Jun-01-2021, 05:09 AM
Last Post: Pedroski55
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,192 Mar-24-2021, 04:56 AM
Last Post: shantanu97

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020