topic need data form a excel formula cell in Talend Studio

need data form a excel formula cell

Anonymous — Mon, 26 Jun 2017 15:17:30 GMT

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

Re: need data form a excel formula cell

cterenzi — Mon, 26 Jun 2017 16:19:46 GMT

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.

Re: need data form a excel formula cell

Anonymous — Tue, 27 Jun 2017 07:30:41 GMT

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

Re: need data form a excel formula cell

Anonymous — Tue, 27 Jun 2017 07:31:17 GMT

and the second screenshot

picture2.png