Question

What activity can you use to get a column value from a specific row of a data table?

Answer 1

first of all, this is a great community from which I got a lot of help in the past.

I’m still not good with Excel though, so here is a question I have.

I have an Excel sheet with 2 columns. I have the string value of one cell from column A in my clipboard (extracted from SAP) (f.e. A5)

How do I get the value from the cell in the same row in column B (B5) as a string value?

Appreciate all the help.

Thanks,

✌✌✌✌✌✌✌✌✌✌✌✌✌✌✌✌

Answer 2

Answer:

. Gets a value from a DataRow variable according to a specified column.

• 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.