How to select a particular cell in excel

Hi everyone,

I have a non-fixed excel table. The number of rows and columns of the table can vary each time.

In the GYD column, I need to copy the cell where the cell containing the word “Tlm” and the TT column intersect. For example, if the GYD column is in column A, if the word “Tlm” appears in the 17th row of the GYD column and the TT column is the C column, then I want to copy C17. In the screenshot below, you can see the cell I want more clearly. I think someone in here may help me. Waiting your ideas:)

Best regards,

@mazlumkacar

  1. Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’.

  2. And then use ForEach Row Activity to iterate that DataTable.

    ForEach row in DT
        If row("GYD").Tostring.equals("Tlm")
        Then print row("TT").Tostring
    
6 Likes

Do the following:

  1. Convert the excel to data-table
  2. Filter the data-table with first column to search for “TIm”
  3. Get text from the 3rd column “TT” and extract the info :slight_smile:

Hope this helps :slight_smile:
Cheers @mazlumkacar

1 Like

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