Openpyxl Output Formula Results, Not Formula Into Cells
I'm trying to finish a script to convert an Excel file. It iterates through rows in a column, and creates a formula which cleans data in another column. Here is my code so far: imp
Solution 1:
Unfortunately, I don't have Excel but this code works fine in LibreOffice Calc. May be executing formulas is somehow forbidden in Excel and you should manually allow it?
Also you need range(2, max_row + 1) otherwise it won't work for the last row.
Solution 2:
The documentation is quite clear on this http://openpyxl.readthedocs.io/en/latest/usage.html#using-formulae
Post a Comment for "Openpyxl Output Formula Results, Not Formula Into Cells"