读取excel中,公式的计算值:
import openpyxl
workbook = openpyxl.load_workbook(file_path, data_only=True)
writed_sheet = workbook[sheet_name]
str = writed_sheet.cell(0, 0).value
print(str)
结果为:None
解决方案:
添加下列代码:
from win32com.client import Dispatch
def just_open(filename):
xlApp = Dispatch("Excel.Application")
xlApp.Visible = False
xlBook = xlApp.Workbooks.Open(filename)
xlBook.Save()
xlBook.Close()
原代码变为:
just_open(file_path)
workbook = openpyxl.load_workbook(file_path, data_only=True)
writed_sheet = workbook[sheet_name]
str = writed_sheet.cell(0, 0).value
可以得到正常的结果。