Can't read formula in read-only mode

Issue #923 duplicate
Hưng Nguyễn Quốc
created an issue

I used this code to load workbook, but the value of some formula cells just are equality signs. Have you guys seen this matter before?

from openpyxl import load_workbook
wb = load_workbook(filename='test_memory.xlsx', read_only=True)
ws = wb.worksheets[0]
for row in ws.rows:
    for cell in row:
        if cell.data_type == 'f' and cell.value is not None:
            print(cell.coordinate, cell.value)

Comments (3)

  1. Log in to comment