Read values corresponding to a formula from excel to talend

[Anonymous]

Hi,

I have a requirement in Talend to read two columns from an xlsx file, but the problem is that one of the columns that I need is a measure whose value is supplied by another excel through a formula. So the Talend metadata is picking up the formula instead of the corresponding value. The environment is hosted in Unix.

Is there any way to work around this without making any change in the input excel?

Any Help would be appreciated!

[Anonymous]

@lli is this something your Excel components can handle?

[Anonymous]

Yes this works.

[Anonymous]

Here an example of a job using formulas with printed input and output 

[Anonymous]

The showed job is a complete roundtrip. It works well also if the excel file already contains the formulas. In the topic use case the formulas are already in the file to read, no problem.  

[Anonymous]

Thanks Jan!