Just for a trial, can you bootstrap that Excel sheet once in the OutSystems Entity and see what data it brings there!!

If it brings the calculated value then we will need to look at different approach but if it fetches the formula then we are going in right direction and efforts will be to fetch data as it is.

Please let me know the results. I will also try it at my end once reaching to the desk. (Outside at the moment :p)

I have done this practically and achieve to get the formula -

The Problem Is:

When we set the Excel to display Formula instead of Value - it shows the formula but that's a view only. In the actual results it is the calculated value. So, the data sent to the entity is Value but No formula.

It is sending Value instead of formula because of =

Have you noticed in the formula data it has = as prefix that initiates the Math in excel.

Is it possible to read the formula inside a cell instead of the value?

Ex:

In this example, I would read the formula inside B2 (=A2*3) and not the value (6).

With the Cell_ReadByIndex Action it is possible to read the value in the cell but not the formula.