Does xlrd evaluate excel before reading values?
I am trying to read excel using pd.read_excel()
but this doesn't read excel cells that contains formulas. Not even after applying data_only=True
.
I'm wondering if xlrd is able to read excel cells that contains formulas and does it evaluate the formula before reading them?