How to get the last row of an excel spreadsheet column with a specific value

Hi Guys,

Hope everyone is safe, and well.

I would like your help with some doubts that made me be stuck in a project for 2 weeks.

I Have a spreadsheet that i want to fill automatically with RPA, but i was not able to get the last row that contains the ‘OBRC’ value, and them use this rowIndex to fill the other information in the cells.

Would you guys help me out ?

@Lucas_Silva Use To get Last Row use DT.Rows.Count there u will get last row of Index.

So i need a read range activity to get the last row, but the row i need has a value that is ‘OBRC’ how can i do it ?