Four Stars

need data form a excel formula cell

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

3 REPLIES
Ten Stars

Re: need data form a excel formula cell

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.

Four Stars

Re: need data form a excel formula cell

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.

Four Stars

Re: need data form a excel formula cell

and the second screenshot