Read Excel Cell Value and Not the Formula Computing It -Openpyxl

How do i Get the Values in Excel cells and not the formular Using any Pyhton Package and also how to read from a excel file using the same package

When you load the workbook, set the flag data_only to True

wb = openpyxl.load_workbook(filename, data_only=True)

I want to read a cell value, not its formula

According to How to access the real value of a cell using the openpyxl module for python
when loading the workbook you have to set data_only to True: wb = load_workbook("file.xlsx", data_only=True)

Getting value from Excel cell with formula via openpyxl

Make sure you are using data_only=True when loading the workbook:

import openpyxl

workbook = openpyxl.load_workbook(filename, data_only=True)
worksheet = workbook.active  # active worksheet

print(worksheet.cell(column=10, row=5).value)

Be aware: Excel stores evaluated values in the file. That said, these values are only available if the file was opened with Excel (or maybe with a similar application) before.

Openpyxl is not able to read function value refering to a cell which it wrote into previously

openpyxl does not and will not calculate the result of formulas, hence the formula B1=A1 will only be calculated when you open the excel sheet or use another program that will calculate it. There are other libraries that I believe can help, like pycel.

Openpyxl 1.8.5: Reading the result of a formula typed in a cell using openpyxl

openpyxl support either the formula or the value of the formula. You can select which using the data_only flag when opening a workbook. However, openpyxl does not and will not calculate the result of a formula. There are libraries out there like pycel which purport to do this.

read excel formulas modified with openpyxl

When you write '=B1 + B2' in cell B3 of your excel file, this is a macro/command which will be played by Excel when the file will be opened in excel, so read_excel or openxls can't play with it.

---

Related Topics