Welcome to uipath community
We got THREE options to get the exact cell value
—either we can use READ CELL activity within excel application scope
—use a excel application scope and pass the file path as input
—inside the scope use a READ CELL activity where we can mention the cell range from we want and get the output with a variable of type string named str_output
We can use GET ROW ITEM Activity where we can mention the details with these properties
Row - The DataRow object from which a value is to be retrieved.
ColumnIndex - The index of the column whose value is to be retrieved from the DataRow.
ColumnName - The name of the column whose value is to be retrieved from the DataRow. If this property is set, then the ColumnIndex property is ignored.
Column - The DataColumn object whose value is to be retrieved from the DataRow. If this property is set, the ColumnName and ColumnIndex properties are ignored.
This would give us the value we need from exact cell of excel
But before using get row item activity we need to use excel application scope and read range activity to get the datatable of that excel
We can simply use a assign activity
—use a excel application scope
—use a read range and get the datatable variable
—now use a assign activity and mention like this
Usually row index and column index starts from 0 for first row and first column
Hope this would help you