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