I’m automating using excel and I need to get the first value of a specific column. For example, in Column A, I need to get the first value then perform if statement. Anyone here can help me?
You should have to use string split method.
or you can get the first value by the below method using assign activity
char ch = ColValue.ToCharArray().ElementAt(0);
ColValue is a variable and this variable value comes from the excel cell value.
Hello @abu.behlim thanks for this! it works!
I use assign activity
result = row(“Name”).ToString.Substring(0,1)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.