+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Homework (https://python-forum.io/forum-9.html)
+--- Thread: Excel formula in python using Openpyxl (/thread-19033.html)
Excel formula in python using Openpyxl - shernel - Jun-11-2019
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!