Excel reading many columns

[evan.joy.celino]

Hello everyone. Can the Get Row Item activity get 10 columns at a time? or it is only limited to 1 column per 1 Get Row Item Activity? Is there a substitute activity that can get 10 columns at a time?

[Eric_Wong_Test (Eric Wong)]

You can use Read Range Activity and set the cell you want. It will store to Data Table

[evan.joy.celino]

Hello. It worked. Just a question, if I am trying to get this column in excel using Get Row Activity,

Personnel Number
12324
12324
12324
12324

and put it in a variable name personnelNumber, what should be the data type of the variable personnelNumber?

image below

[Eric_Wong_Test (Eric Wong)]

In the For each row, you can use Assign to get value like
personnelNumber = CurrentRow.item(8).ToString
personnelNumber is String