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
