Python reads only the formula from excel cell

4
votes

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

enter image description here

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.)

enter image description here

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.

2
pythonexcelopenpyxl
possible duplicate of Read Excel cell value and not the formula computing it -openpyxl – Nagaraj Tantri

2 Answers

11
votes

From: https://openpyxl.readthedocs.org/en/latest/usage.html#read-an-existing-workbook

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)
0
votes

You can use xlrd module and do the reading easily.

read_fullreport = xlrd.open_workbook(report_to_read)
read_fullreport_sheet = read_fullreport.sheet_by_index(0)
ipAddressofMC = read_fullreport_sheet.cell_value(row_nr, col_nr)