Jun-11-2019, 09:15 AM
one workaround is
1. open file once with data_only=True and read column E values into memory
2. open the file second time and populate column G using values you read into memory in step 1
another option is to calculate values from column e in your script (in your example I see column e is result of multiplication of values in column B)
yet another option is to use different library like xlwings instead of openpyxl
1. open file once with data_only=True and read column E values into memory
2. open the file second time and populate column G using values you read into memory in step 1
another option is to calculate values from column e in your script (in your example I see column e is result of multiplication of values in column B)
yet another option is to use different library like xlwings instead of openpyxl
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
