How to apply excel expression on excel through Knime?

There has been the suggestion to use xlwings to evaluate the results. Have not used it yet.


you can use xlwings to get the formula evaluated by excel:

import xlwings as xw
wbxl=xw.Book('to_erase.xlsx')
wbxl.sheets['Sheet'].range('B3').value