I have an excel file with different columns, see the picture below.
I would like to get the highest value of Column 1. For this I used the excel application scope with read range with output “dt1”, after that an assign activity where Maxvalue = dt1.AsEnumerable().Max(Function(row) row(“Column 1”))
The Maxvalue variable is set to Object. When I use the write line activity to check it out, I get an error saying: “Object must be of type Double”. When I change the variable type to double, the assign activity will pop an error: Conversion from object to double is not allowed because of the Strict On option.
Can anyone help me with this?