By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

How do I use complex formulas in OpenPyXl

P: 1
0


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!
Jun 10 '19 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.