Skip to main content
  • EN

i have information table1 like below

Colomn\\RowABCD1SNSFruitCOSTQuantity21Apple20per Peace32Banana3per Peace43Orange8per Peace54Mango50Per KG65Cherry250Per KG76Papaya40Per KG87Graps80Per KG98Dragon200Per KG109Kiwi30per Peace1110CustedApple60Per KG1211Fine Apple40per Peace1312Green Apple25per Peace

 

and having another table2

Colomn\\RowAB1Fruitapple2Price

 

 

i need write value at table2 Cell position B2 with 20 from table 1

Hi @rakeshreddy0996

 

There is a insteresting Webinar about Excel files in FME: https://www.safe.com/webinars/tips-automating-excel-data-processing-tasks-fme/

 

In the feature type on Writer you can set the position:

 

Thanks in Advance,

Danilo

Just to answer the subject, if you use a FeatureWriter to insert into an excel file you can specify the Start Column and Start Row to make your "20" plop down in B2. That's an easy way to do it if your excel file already exists with the desired layout and your workspace is outputting the "20".

Hopefully this workflow could help you. The NumToAlphaConver is a custom transformer from FME Hub, which converts 1 to 'A', 2 to 'B' ... and so on.

Just to answer the subject, if you use a FeatureWriter to insert into an excel file you can specify the Start Column and Start Row to make your "20" plop down in B2. That's an easy way to do it if your excel file already exists with the desired layout and your workspace is outputting the "20".

could please brief

 

Thanks

Rakesh reddy

Reply


Community Stats

29,728
Posts
112,952
Replies
37,374
Members
Terms & ConditionsCookie settings