python读excel单元格,Python仅从Excel单元格读取公式

I have a excel 2010 file which has cells (See C2 below in formula bar) with formulae. (Screenshot 1 below)

I am reading the value using python and it's printing the formula instead of actual value of the cell (Screenshot below of eclipse console.)

I want the results to print 10.188.11.184 which is the value populated by the formula of the excel cell. How can this be achieved? Thanks in advance.

解决方案

data_only controls whether cells with formulae have either the formula (default) or the value stored the last time Excel read the sheet.

wb = load_workbook('file.xlsx', data_only=True)