How to make the robot read the whole column and not just the cell

Help Studio
,
1

Hi, I’m trying to make my robot read a column in an excel file and type the information in a website but it reads just the cell.
I tried to use the Read Range activity and the For Each Row in Data Table but it doesn’t work. I guess I’m putting the wrong range.

image

image
image728×529 27.4 KB

image
image264×701 6.5 KB

2

@beatorres2 follow the steps

  1. Read Range activity and create its output variable “readDT”

  2. For each row activity and pass the readDT in in text field

  3. Use type into activity and here you write

CurrentRow(“ColumnName”).ToString

3

Hi @beatorres2
If you want to read just one column from excel, then follow these steps.

->use read range activity
And give range from start of the column to end of column
Like this “A1:A23”
Give datatable as output DT1

→ use for each loop over DT1
->use Type into activity inside loop and give type into → CurrentRow.Item(“Data da Compra”).ToString

scenario 2
If you want to read the whole data table from excel then there is no need to give range.leave blank

Remaining steps will be same as First scenario.

Thanks

6

Nothing happens, the robot just stops running

image
image898×697 27.7 KB

image
image1062×617 30.7 KB

7

Same as the other one, nothing happens =(

image

8

Should I put something on Column count or Header names?

9

What error you are getting? Could you share the error screenshot?

10

Now it doesn’t show any error but keep putting in the browser the sentence that I put on Type this, and not the cell value

image
image
image

11

Hi @beatorres2 - Before type into can you print currentRow.Item(“colname”).Tostring in a message box and see what it is giving

12

Hi, @ushu .

I guess it’s not working because it’s showing this message:

For Each Row in Data Table: Object reference not set to an instance of an object.

13

Hello @beatorres2

As per my understanding there is an issue with the datatable. Please make sure datatable is having the data from excel.

You can run in debug mode and check in the immediate panel for the value of datatable.

Thanks