Mimic Excel Formulas in FME

Hi ​@aashnaparikh Are you looking to recreate the vlookup formula so it is written in the output spreadsheet?

Also for writing multiple sheets to one excel file the FeatureWriter works well using multiple data streams as input. 

Hi ​@crutledge, 

The context is I have a reader file with 7 attributes and 400 features. Now these features needs to be mapped straight to the 7 attributes in my writer. However there are other attributes in the writer that have a static value ( which I have defined using the attribute manager) and then there are attributes where the calculation is based on 2 different instances. The 1st instance is where the formula is calculated based on the attributes sitting in the same sheet i.e Standard Sheet and the 2nd instance is where the formula is calculated based on the data from the limits sheet. 

My initial approach was to overwrite an existing template using the feature writer but it did not seem to populate the data correctly. 

Now I am approaching the 2nd route where I manually define the formulas within FME and generate the excel file which is exactly similar to my template without overwriting it. 

The output should have 2 sheets Standard and Limits with data being written to Standard Sheet. 

Hi again ​@aashnaparikh 

Yup. I think the FeatureWriter is definitely where you will get the two sheets output you want. To get there, however, you could simulate the vlookup for the “in sheet” value matches using a conditional statement.
 

While for the comparison between sheets you might have success using a Matcher transformer and the fme_feature_type will allow tell you the source of the matched records.
 

Let me know if I am following. I know there is a better way to do this but this is all I can come up with or now. Gears are turning. I hope that helps.