Argument Value

Help Studio
, ,
1

Dear All
I don’t know when the following msg shown up, where or how do I fix it?
Thanks a lot.

image
image809×528 18.4 KB

image
image886×115 16.4 KB

2

check if for each row activity maybe better suits
ensure when working with for each activity that the typeargument is set to datarow
kindly note your spelling issue. it was defined Row but later used row, so correct the case for R

3

@Apple In For each In field you have passed a string instead of the datatable variable also check the type argument

4

hi…
Do you mean this?I’ve changed to String, it still doesn’t work.
Thanks a lot.

image
image815×217 13.5 KB

5

try this

Row.item(4).ToString

make the R capitalized

regards
ahmad

6

Hi @Apple ,

Please do let us know What you are trying to Perform along with the issues faced.

We do have a confusion between Using the For Each Row or For Each Activity.

If required to Read the Contents of Excel which is Present in a Datatable, use For Each Row with Datatable variable from Read Range Activity as Input.

If required to Iterate through each character of a String. Try Changing the TypeArgument to Char, then just use row.ToString

Let us know what is the outcome and what you intend to perform.

7

Hi Superman,
I would like to Read the Contents of Excel which is Present in a Datatable.
Do you mean I should use this following activities instead of for each activities?
image

8

@Apple ,

Yes. You should Try to use the For Each Row in Datatable Activity.

It Should help you iterate through each of the rows present in the Datatable, which is in turn the contents of the Excel which you have read using Read Range Activity

9

hi Sir.
It work now. however, It only input data once from the row of excel data table. It didn’t iterate all the row (that’s say there are 10 rows and it only input data once which is from the last row).
Not sure what else activities I need to use? for example: write line or
Assign i=1 or If ? Thanks a lot.

image
image614×565 22.1 KB

image
image461×539 20.3 KB

For example:
It only typed into the data(40731653845) in the last row, didn’t type input data from the first row to the last row in the column E(Phone Number)
image

Thanks a lot.

10

@Apple ,

We would need to use the Type Into Activity inside the For Each Row Activity, after the Assign

11

Thanks it works

1 Like
12

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