I have the to read a cell containing a result of a formula: but the result is always 0 cell G26, despite the format i used for the extracted value (output of read cell G26 cell): double, generic, string…
always when i read the whole sheet into a datatable, i found always 0 for cell G26
It seems value of D26 and E26 is recognized as not numeric but string which has comma as decimal point. As a result, it throws error. Is this file output from Excel? It seems to have illegal format.
If data is input as numeric correctly, Read Cell activity can handle it as numeric.
So, probably this is reason why the formula returns 0 by Workbook - Read Cell activity.
Hi @abdel , just wanted to check the status here - were you able to get this to work? If not, would it be possible to share with us the project to help us troubleshoot this?