As per my project, I am using “SAP GUI interface”. As I am trying to extract the values from excel like interface (which has cells as shown in the below figure).
Note:- “For each row activity” cannot be used into this SAP GUI interface.
I need only two values into two variables- (2,406,289,170.66) and (503,145,385.61) from the image above.
While I am using (Ctrl - C) and (right,down, up, left ) hotkeys to traverse through the cells and extract values, the entire row is being stored in the string variable instead of getting only one cell value.
Anyways, I tried to split the entire row (which is being extract) using string array variable like:-
strArGrandTotalRow = GrandTotalRow.ToString.trim.Split(" ".ToCharArray)
and trying to print the strArGrandTotalRow(0), entire row is being printed.
As I am printing the clipboard value into notepad, I am getting string as shown above.
I also tried, strArGrandTotalRow = GrandTotalRow.ToString.trim.Split("\t".ToCharArray)
But still it won’t work.
Thanks and Regards,