title: Python to read Excel cell with the value calculated by the formulas but not the formula strings themselves
body: <p>I am using Python openpyxl package to read values from Excel cells. Cells with formulas always return formula strings instead of the calculated values. I'd rather avoid using 'data_only=True' when loading the workbook as it wipes out all the formulas and I do need to retain some of them. Seemingly a problem not so difficult but turns out to be quite challenging. Appreciate it very much if anyone can shed some lights on this. Thanks a lot!</p>