Read range

Help
1

I get exception in Read range of workbook, “Sequence contains no matching element”

Could you help out?

2

@blaze.1411

If you are checking for any matches and it not found means it will happens, Can you upload the xaml and test data, so that i can try to solve this.

3

Hello @blaze.1411

Could you please, give more details about your question?

How are you performing reading?

4

I have used Read range from workbook activity, given excel path “in_Config(“FileLocation”).ToString” sheet name as “FileInput”.

output variable as assigned in argument “out_dtUserData”

5

I am not using finding matches in the activity.

6

@blaze.1411
Apparently it’s correct, but can you print the error or share the flow to check?

7

“Sequence contains no matching element” is the exception.

Sorry i could not upload the screen or workflow as its a banking sequences.

8

@blaze.1411

Please, check the link below:

9

good evening. can any one tell he how to read range from a specific cell onwards till the last value in that excel sheet. for an example i want to read all the rows from “A13” to “A300”. how can i do that.???

10

Hello @sathwikreddy

You can try this

image
image869×243 12.6 KB

11

@sathwikreddy just put “A13”

1 Like
12

then it reads only that cell value…i want to read from that cell to the last cell present in that sheet.

13

thanks fro the reply…but there is a problem…what if my next excel sheet has more than “A300” cells…then i have to update it physically…i want to read till the last value present in that excel…

1 Like
14

thanks for the reply…

15

@sathwikreddy
Ok, So you should only do @Pablo_Sanchez suggest for you

1 Like
16

no bro…when i have bulk data which has more than “A300” cells… then i have to manually change it…

17

@dkollyns thanks for the link,

The link contains about starting a job through orchestrator, whereas my environment and development is without orchestrator which even doesn’t have excel office installed in the machine environment.

18

Hi @sathwikreddy

If you just write “A13” and UiPath is just reading 1 cell, the reason is that you are using read cell activity (OMG xD)

If you use read range activity and you write “A13” it will read the whole range since A13 cell until the end of the data cells.

Regards!

19

Hello @blaze.1411 ,

Have you got the solution for this ??