Troubles with "Get Row Item"

Help Studio
, ,
1

Hello, May I ask what can I type under ColumnName in “Get Row item” for an excel sheet that does not have a column name? Can I put the cell reference?
Thank you

2

Hi @deborah_yeong

You can give column index as well,

image

or if you want to column name (say 3rd column),

dt.columns(2).columnname

will give the column name for 3rd column.
dt is your datatable

Thanks

3

Do you mean by cell reference of that column?

4

yes the column index you want in your datatable.

Thanks

5

Btw is read range only for datatable?

6

the activity is available for the use along with a data row from a datatable. In case of the data column names are not popoulated e.g. by the first row from an excel, auto generated column names are set. So we can use this or the column index as mentioned by Prasanth

1 Like
7

@deborah_yeong yes its for datatable.

Thanks