How to create FME workbench so it reads excel Formula? it needs to read columns with no formulas and give the values in that column and then also columns with formulas and give back those formulas
P.S. Get FME to read those formula directly from the excel sheet and give the output back
Userlevel 4
- 8177 replies
-
1 June 2017
When creating the reader, click Options and make sure "Read formulas" is checked. It will then create an extra attribute with the suffix ".formula".
Example: your Excel sheet has a column "my_value", FME will then create the attribute "my_value" and my_value.formula" on the reader:
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.