I am printing some formula in one of the Excel sheets:
wsOld.cell(row = 1, column = 1).value = "=B3=B4"
But I cannot use its result in implementing some other logic, as:
if((wsOld.cell(row=1, column=1).value)='true'):
# copy the 1st row to another sheet
Even when I am trying to print the result in the command line, I end up printing the formula:
>>> print(wsOld.cell(row=1, column=1))
>>> =B3=B4
How can I get the result of the formula in a cell and not the formula itself?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…