I have an excel template sheet that has some formulas in it. I use pandas to populate some of the columns in that sheet and then the formulas use that information to return a numerical value. Once I am done I save down the file.
When I try to copy that sheet with the formulas and use the information from it using pandas, all the cells where I have formals come back as NaN. If I manually open the excel file, press Save, and close out of it, then pandas reads the cells with the formulas as the numerical values, which is exactly what I want.
How can I get around the opening, saving, and closing the excel file manually every time, and have pandas be able to immediately read the numerical values from the formula cells instead of reading them as NaN?
