Reading integers from excel


#1

Reading numeric values from excel is always returning decimal value and not integer. I use Get Range action to read the values into a table variable.

excel

For example in the above image if i try to read the first row , all the numeric column values are read as decimal values (if number required is 1 it is being read as 1.0)

Is there a way to read as an integer?
I have tried setting the column type in excel as number,general and text, but the value returned is always a decimal


#2

@abhaya_jeyar,

This is a known issue, we will introduce the Type Conversion action in future releases to solve this case.

Currently you can use the Text > Substring Between action with "Extract text before" = "." option