excel - 使用 openpyxl 打印公式的值

Question

在过去的两天里，我一直在尝试对此进行研究，我看到的最常见的答案是使用 data_only=True 但这似乎并不能解决打印公式值的问题。这是我的脚本。有人对此有答案吗？

import os
import openpyxl
from openpyxl import Workbook
from openpyxl.reader.excel import load_workbook
from openpyxl import load_workbook
import csv
directoryPath = r'c:\users\username\documents\reporting\export\q3'
os.chdir(directoryPath)
folder_list = os.listdir(directoryPath)
for folders, sub_folders, file in os.walk(directoryPath):
    for name in file:
        if name.startswith("BEA"):
            filename = os.path.join(folders, name)
            print filename
            wb = load_workbook(filename, data_only=True)
            sheet = wb.get_sheet_by_name("Sensor Status")
            for row_cells in sheet.iter_rows(min_row=1, max_row=4, min_col=8, max_col=13):
                for cell in row_cells:
                    print cell.internal_value

标签： excelformulaopenpyxl