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


Messages In This Thread
Want to add formula to excel sheet - by nagu4651 - Dec-24-2019, 03:03 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 2,315 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Help using a dynamic array excel formula with XLWings FXMonkey 2 1,491 Jun-06-2023, 09:46 PM
Last Post: FXMonkey
  how to read txt file, and write into excel with multiply sheet jacklee26 14 11,261 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Openpyxl manipulate excel write formula SamLiu 0 1,221 Nov-04-2022, 03:00 PM
Last Post: SamLiu
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 7,783 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  {SOLVED]Help getting formula value in Excel to a csv Pedroski55 1 2,173 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,847 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,853 Jul-07-2021, 02:06 PM
Last Post: Marbelous
  Python script for excel sheet Nabil 4 3,527 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,330 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