openpyxl 表格无法读取公式数据

Question

我使用openpyxl 写入 需要反复的写入公式并且，把结果数值化 ，循环执行，现在执行数值化之后 打印为 None。

使用如下代码打开在关闭一次，在使用data_only=True读出公式计算的值：
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()

但是最后结果却是 pywintypes.com_error: (-2147221005, '无效的类字符串', None, 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()

workbook = openpyxl.load_workbook(r'D:\jtyl\imgs\柔跨梁货架参数需求及选型计算.xlsx')

sht1 = workbook['02货架选型表']
for j in range(1, 2):
print("输入的是E24",j)
# write_to_excel('e24', j)
sht1.cell(row=24,column=5,value=j)

# a0 = ['E18', 'F18', 'G18', 'H18', 'I18']
for i in range(5, 6):
    print(i)
    # write_to_excel(a0[i], 1)
    sht1.cell(row=18, column=i, value=1)
    workbook.save(r'D:\jtyl\imgs\海柔跨梁货架参数需求及选型计算.xlsx')
    workbook.close()
    just_open(r'D:\jtyl\imgs\海柔跨梁货架参数需求及选型计算.xlsx')
    workbook = openpyxl.load_workbook(r'D:\jtyl\imgs\柔跨梁货架参数需求及选型计算.xlsx',data_only=True)
    sht2 = workbook['03-构建清单']
    a2 = sht2['Z12']
    b2 = str(a2.value)
    print(b2)

我想要达到的结果

循环一次就转换一次数值