Here an example: I sould extract the value “55,80”. I thought about a switch case cycle combined with sget value() but i would like to know whether there is a more elegant solution

I need to select the maximum value of this row. I thought about a switch case combined with get value() but i would like to know whether there is a more elegant solution

First, read the table to DataTable using ReadRange activity. (Let’s say dt)
Then, the following expression will return max value of the row #0. Please modify to row number which you want to calculate

Thank you. I was looking for something like that. Uipath throws an error " the object must be a double". I tried to convert dt.Rows(0).ItemArray.Max to a double with convert.toDouble but it doesn’t work

Hi. It Works. Thank you very much. Could you explain me the formula? you first convert the columns in DataColumn, the you apply the max function. In the max function why do you write “Function(c)” ? and then you try to convert the max value into a double value, if true you convert it into a double value, otherwise you convert it into the minimum value of double? why do you do so?

In the max function why do you write “Function(c)”

It’s lambda expression of LINQ. We need to think it as one of syntax of VB.net.

and then you try to convert the max value into a double value, if true you convert it into a double value, otherwise you convert it into the minimum value of double?

In this case, we need to get max value. So, if the invalid data is converted to Double minimum value, it won’t be selected as max value.
And, it’s also good way to use Where method to achieve it, as @J0ska mentioned.