+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: OPENPYXL (/thread-19016.html)
OPENPYXL - shernel - Jun-10-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!
RE: OPENPYXL - Larz60+ - Jun-10-2019
see: https://python-forum.io/misc.php?action=help&hid=52