topic Re: How to read excel formula cell value and then write in Talend Studio

How to read excel formula cell value and then write

Anonymous — Thu, 09 Feb 2017 10:58:07 GMT

Hi Team,
How to read excel formula cell value and then write in any logrow or database etc

Re: How to read excel formula cell value and then write

Anonymous — Fri, 10 Feb 2017 02:12:20 GMT

Hi,
What's kind of l formula cell do you want to read in your excel? Could you please set an example for us? Is it Ok with talend built_in component tfileinputexcel? Or have you already checked the custom component tFileExcelSheetInput shared on talend exchange portal?
Best regards
Sabrina

Re: How to read excel formula cell value and then write

Anonymous — Fri, 10 Feb 2017 04:05:59 GMT

Thanks Sabrina for you response.
My requirement is im using tExcelReport its output is as below.

Column A	Column B	Sum
100	200	$
200	300	$
300	400	$

Now i want to read the last sum column .
When i simple read it in tLogrow it shows the Sum column values null.
I have not checked the custom component tFileExcelSheetInput.

Re: How to read excel formula cell value and then write

Anonymous — Mon, 13 Feb 2017 05:58:49 GMT

Its urgent please revert

want to read D column values