Excel data table

I am having a data table , i am having IDs in first column , how can i access the first id of my table.

Hi @palanikumar,

Try using the Read Range(it stores to a data table).

For example,
datatable.Rows(0).Item(“ID”).ToString

(0) tells it to use the first row - (1) would be the second row, etc
and .Item(“ID”) is the column.

Regards.

Hi @palanikumar
If you want to read the only one Id then you can use Read cell activity and if you want to read the Whole ID Column Then Use For each row activity and give the output of read range to it and inside it use the get row item. in the properties panel of get row item you can provide name or column index.
Thanks & Regards

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