need data form a excel formula cell

[Anonymous]

Hello,

when i read the data from a excel shht that contain a row that will be a formula it returns "NULL" or "#VALUE". How can i get the calculate value of the cell. e.g.

ROW A | ROW B | ROW C

1          |  2          |   =A+B

When i read the File with the component "tFileExcelSheetInput" or "tFileInputExcel" i get "NULL" or "#VALUE" How can i get the Result "3"

Thanks and Regards

Andreas

[cterenzi]

I'm assuming your excel sheet looks more like:

ColA     ColB     ColC
 1        2       =A2+B2

If so, then this should work fine.  If not, please show a screenshot of your Excel sheet and include the formula in question.

[Anonymous]

yes it looks so. but it don't work. in the screenshots you can see the excelsheeet and the result in talend. in my question it  will be only a simple example.

picture1.png

[Anonymous]

and the second screenshot

picture2.png