Excel Part

[Ak_4]

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.

[mahmoud.zaky]

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

[Anil_G]

@Ak_4

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

[Kaviyarasu_N]

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