First Post. Please delete if not allowed.
I am a new user to KNIME. I am using the XLS Reader node to import an excel table. However, this table contains numerous formulas in most cells. When I try to import it, I am receiving the #XL_EVAL_ERROR#. Is there a way to read the computed data in the cell or am I forced to copy/paste value in excel? I am charged with automating as many steps as possible, so I am attempting to avoid that.
Thanks in advance