Skip to main content
Question

Trying to read formulas with information on different sheets and with formulas in a dynamic table in Excel

  • September 19, 2019
  • 1 reply
  • 21 views
A
Forum|alt.badge.img

Dear people,

I have an excel file which contains a dynamic table, in this table there are formulas referencing to parameters on another sheet.

Without going into detail, there needs to be a recalculation of certain coordinates. So far i was able to get an excel sheet with the extracted coordinates into the right order and structure.

At this point I just want to write away this coordinates into the excel file dynamic table and let excel do the calculations so i can use these new coordinates further on into my module.

So the problems i have are:

1) How do i write away the data into a dynamic table? Now it just puts my data underneath the table...

2) Is it possible for FME to get the values of parameters which are written on other sheets but in the same excel file to do this calculations (also the sheets don't look the same, different columns etc.)

Any ideas that can put my in the right direction will be greatly appreciated,

If you need any further info, just let me know, I hope you people can help me again.

Thanks in advance,

Andreas

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • September 19, 2019

You should be able to create a named range in a template file and then write your data directly into that named range

To write to a named range, in the Sheet Name in the reader you use Sheet Name/Named Range

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.