How to read the entire row within a range in excel

Help Activities
,
1

I am trying to read a set of rows in excel, to be able to extract the data of each column to a variable, I am somewhat lost, how can I do it?

I have seen read range, but it only reads me a single column, and I need all the columns of all the rows

thanks

2

Hi @Kuro

Welcome to the UiPath Community.

Can you try with “Range” being empty

image

3

Hey @Kuro by default the range value is “A1” so the read range will read only “A1” cell value
if you want to read the entire table then clear the range value or if you want only parrticular range values then pass the range there
Example of passing range values “A1:D3”
A1 will be starting node and D3 will be ending node…

Thanks and Regards

Sreejith S S

1 Like
4

HI @Kuro

Welcome to UiPath community

Have you tried with Read range activity with Range -> ""

Regards
Gokul

5

Can I see somewhere an example of reading all the lines and columns?

6

This will read all the columns and rows in the excel @Kuro

image

Regards
Gokul

7

Thanks, at that point I was, but my excel has 6 columns per row, how can I put that data in a variable row by row?

8

HI @Kuro

  1. Use Read Range activity → Store it as DtRead

  2. Use For each row in DataTable activity

image
image937×414 20.6 KB

Regards
Gokul

9

Thanks again, I want it to start at row A11 onwards, do I put A11 in range?

10

Yes @Kuro , You can do it.

11

I have set it to start at A11, and I understand that the columns are called A, B, C…so to display the table data I use this CurrentRow(“B”).ToString

Because I need to retrieve the data of B, C, D, E of each row, thank you very much for your help

12

Have a look on the UiPath Academy

Do you have any other queries @Kuro

If not, Kindly close this topic by mark as solved. It will help for other too

Regards
gokul

13

I just saw a problem, from row A1 to row A10, they have to be deleted before putting the data in DataTable, I have put the delete range activity with the range “A1:A10”, but it does not delete them, maybe something i’m doing wrong

14

Create a new topic for this queries. I think this is out of topic @Kuro

15

thanks for all

16

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