Skip to main content
Solved

Calculating values in excel

  • February 5, 2025
  • 4 replies
  • 68 views

teresa_ro
Participant
Forum|alt.badge.img+2

Hello,

I have an excel files with values in it. I read the excel file, want to use the value from column E (value is 45), use it in a math formular and calculate a new value. At the end the result should be written in to a Feature class in a FGDB. The transformer I want to use is expression value. But the calculation doesn’t work. 

Has anyone an idea? 

Thank you!

Teresa 

 

Best answer by jobvdnoort

teresa_ro wrote:

Hi, 

I use this expression: 

Th result is this:

The text of the expression instead of the calculated value. 

Do I have change the datatype of the input field? 

Thank you!

Teresa 

 

Hee you have to make sure to use @evaluate around the full expression:

 

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

4 replies

jobvdnoort
Supporter
Forum|alt.badge.img+10
  • Supporter
  • February 5, 2025

Hi Teresa,

 

I use a featurereader for this, where in this example I read this Excel file with some numbers:

 

In the inspector it looks like this: (no headers)

 

 

In an attribute creator you can also do some mathmatical formulas

 

And the result:

 

 

Edit: 

You can also do the same thing with the expression evaluator:

 

 

Result:

 

Is this what you are looking for?

You can write the result to a GDB using the featurewriter :)


teresa_ro
Participant
Forum|alt.badge.img+2
  • Author
  • Participant
  • February 5, 2025

Hi, 

I use this expression: 

Th result is this:

The text of the expression instead of the calculated value. 

Do I have change the datatype of the input field? 

Thank you!

Teresa 


jobvdnoort
Supporter
Forum|alt.badge.img+10
  • Supporter
  • Best Answer
  • February 5, 2025
teresa_ro wrote:

Hi, 

I use this expression: 

Th result is this:

The text of the expression instead of the calculated value. 

Do I have change the datatype of the input field? 

Thank you!

Teresa 

 

Hee you have to make sure to use @evaluate around the full expression:

 


teresa_ro
Participant
Forum|alt.badge.img+2
  • Author
  • Participant
  • February 5, 2025

Thank you, jobvdnoort, it works! 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings