ADF Desktop Integration (ADFdi)

How to evaluate excel formula in cell of ADF Desktop Integration table component?


I was trying to evaluate excel formula in cell of ADFdi  table component. My try was unsuccessfull, got formula rendered as a literal string in the cell.


Apparently when ADFdi plugin evaluates value expression of particular column, it needs to know what kind of output you expect in the cell. Is it a literal value, o some instructions to excel what value to provide (i.e. formula). Use “T” function to have it rendered as a real excel formula and evaluated by excel in its runtime, i.e.:


About Danas Tarnauskas