We currently have an Excel macro to copy cell data from an Excel source sheet and paste to another destination sheet. Once pasted, we will position those data in particular columns and apply some lookups.
What would be the best approach to mimic such process in FME? Is it feasible to execute all those detailed steps by using FME transformer(s)?
Hi @fmesafejde, this is definitely possible with FME. I suggest taking a look at this guide about working with excel data in fme and this nice writeup about creating excel formulas with fme.
--
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
Great guidance @carmijo . Will use them as reference.