python - PyCharm Excel Reader doesn't show formula values

Question

I have excel sheet which has formula for one of the column. When i try to open the sheet using excel reader it shows 0 as value where it could be proper values from formula. I could see correct values when i open the sheet in ms excel or libreoffice. Can someone advise if there is something i could do to fix this. Similar issue is causing when i try to read the sheet from python script. So i thought it is problem with pycharm/plugin. In the attachment, some are showing values there were not based on formula, but 0 are based on formula.

Attachment

Thanks

Answer 1

等待大神答复