ADF Desktop Integration (ADFdi)

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

Problem

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.

Solution

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.:

 

Leave a Reply

Your email address will not be published.