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