如题,用python(openpyxl)给excel单元格写入了Filter公式,结果打开文件时报错,显示公式有误。代码如下,
from openpyxl import load_workbookwb = load_workbook('test.xlsx')ws = wb['Sheet1']ws['A2'].value = "=FILTER(Sheet!A1:D13,Sheet!D1:D13='N')"wb.save('test_m.xlsx')
请问这是什么原因..