I have a column name as Roll no. in excel.
Roll no.
23
45
67
87
I want to use array
Suppose Roll no.(2) = 67
So how we can assign and do it.
I have a column name as Roll no. in excel.
Roll no.
23
45
67
87
I want to use array
Suppose Roll no.(2) = 67
So how we can assign and do it.
Hi @Ak_4,
1- Use Excel Scope and read range activity.
2- Output will be Data Table.
3- use Assign activity DTVariable.Rows(2).Item(0).ToString
Please check and update us if any thing not clear
Read the data into datatable…then you can access as dt.rows(2)(0).Tostring
or if you are specific about array can convert to array as below
Arr = dt.AsEnumerable.Select(function(x) x(0).Tostring).ToArray
Arr(2) will give 67
Hope this helps
Cheers
Hi @Ak_4
You can extract the data from a datatable directly without converting it into an array.
Ex:
Datatable.Rows(Index).item(0)
Regards,
Kaviyarasu N
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.