Python Forum
Excel formula in python using Openpyxl
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel formula in python using Openpyxl
#1
I have a list of data in .xlsx The data is in column W

the data includes 1. ACCEPTABLE 2. UNACCEPTABLE

I want to count the number of ACCEPTABLE and total of both ( ACC and UNACC ) and the formula would be

ACCEPTABLE divide by number of ACCEPTABLE + UNACCEPTABLE * 100

I want the data to be shown at the last row of COLUMN W

The data layout would be same in every workbook only the number of ACC and UNACC would change

HOW WOULD I ACHIEVE THIS IN OPENPYXL?

Thanks in advance!
Reply


Forum Jump:

User Panel Messages

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