如何在pandas/python中查看Excel电子表格的公式? [英] How can I see the formulas of an excel spreadsheet in pandas / python?
本文介绍了如何在pandas/python中查看Excel电子表格的公式?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在excel电子表格中阅读python/pandas,但是要使用公式而不是单元格结果.
I would like to read in an excel spreadsheet to python / pandas, but have the formulae instead of the cell results.
例如,如果单元格A1为25,而单元格B1为= A1,我希望数据框显示:
For example, if cell A1 is 25, and cell B1 is =A1, I would like my dataframe to show:
25 =A1
现在它显示:
25 25
我该怎么办?