How to get the row number of starting cell and ending cell of a certain type of Value in an excel?

Hello Guys.

I am trying to find the range of a certain type of data in a excel sheet. Example screenshot is given below after the description.

the secon column is named “Center”. There are different type of center, I am trying to select the range where it lies.

Can anyone help me?

Thanks
Aryan

What is the purpose of selecting the row?

@Anthony_Humphries

I want to find the range and then the just copy the data directly from the excel.

Thanks
Aryan

Is the Excel sheet you’re reading being put into a datatable?

@Anthony_Humphries

Yes.

In that case, you can filter the table for the center you’re looking for with the Filter Datatable activity. The output will be a datatable only containing data from that datacenter. You can then do whatever you need to with the new data table (e.g. write to a new Excel file).