I need to write a value extracted from an excel row as string inside an command for each row

Hello guys, I am making an flow which extracts the value from an excel and concatenate it to an command run through putty ssh. I need to extract the value as string from the last row and put it inside a string which is a command and I don’t know how to make this working. Thanks!

to extract a row column value from last row
str_input = Datatablename.Rows(Datatable.Rows.Count-1)(“yourcolumnname”).tostring

and use a assign activity like this
str_input = “yourcommand string”+str_input.ToString

then we can use this variable as input
Cheers @Ionut_Frincu

@Palaniyappan Thank you!

One more question please. How can I count the rows? Thanks!

datatable.Row.Count will give you the count

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.