One Star

How to read excel formula cell value and then write

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

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

Thanks Sabrina for you response.
My requirement is im using tExcelReport its output is as below.
Column   A Column BSum
100200$
200300$
300400$

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

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

Its urgent please revert

want to read D column values