I need to do a workflow with the following characteristics:
1º Reading the full Excel sheet [ already done with a simple Read Range Activity ]
2º Read just a portion of the sheet, where a certain word is found on a certain row. I need to keep the cell position saved once this word is found because then, I will need to make a new Read Range starting on that position.
So, basically I just managed to find the value or the existence of the word itself by doing a row(0).ToString = “WordsName”
Now, how can I detect the row index and column index from this word I found? Once I am able to do that, I will need to basically do the same to find the value of the other words whic will give me the position which will make me set the range of the new Read Range activity.