Hi All,
I am trying to import an excel file littered with formulas into a excel reader node but it it coming up with the following error in the cell: #XL_EVAL_ERROR# . I don’t want to carry over the formulas, I just want the results, the raw numbers if possible. A hand would be useful, thanks all
Hi @OliverJault,
welcome to the KNIME Forum. 
The pattern #XL_EVAL_ERROR# is inserted, if a formula can’t be evaluated. Maybe you can check the node’s advanced settings whether you have “Reevaluate formulas” ticked. From the node description:
Reevaluate formulas
If checked, formulas are reevaluated and put into the created table instead of using the cached values. This can cause errors when there are functions that are not implemented by the underlying Apache POI library.
Note: Files with xlsb format do not support this option. For xlsx and xlsm files, reevaluation requires significantly more memory as the whole file needs to be kept in memory (xls files are anyway loaded completely into memory).
If this is not ticked and you still run into the issue, could you possibly share an example workflow for others to reproduce the issue (including a dummy file with meaningless data).
If this setting is not available; which KNIME version are you using?
Kind regards
Marvin
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.