How to use excel ranges in uipath

Help Activities
, ,
1

Hello

I am trying to tell the 365 read range activity to only read from column A to H and have my range as follows :

“Sheet1!$A:$H”

However, when I read it, this is the datatable I get : [DataTable5]

When I just write “Sheet1” in the range, i however get the right columns: [Column1,… etc]

How can I specify the sheet and range in the online 365 read range activity (integration service)

2

had you tried:
grafik

3

i am using integration service read range, is this the classic activity ?

4

grafik
maybe you can share yours as well

5

Hi adext,
Please tcheck the image below:

image
image553×552 14.2 KB

Cheers!

6

hi @jose.ordonez1

this is the message i get

image
image1016×89 6.06 KB

7

Hi adext,
Attached below you can find a demo project.
Demo.zip (9.2 KB)

Hope it helps you!

8

When using the other read range, we can see at the hover help:
grafik
so it is without the dollar

However, we could also read all and the crop with the DataTableVar.DefaultView …

9

Please check if you are using the last version of Microsoft 365 package.

image
image908×508 23.6 KB

10

in addition to above kindly note:
instead of writing within the setting field, we got more reliable success when using the advanced editor instead:
grafik
grafik

11

yes i tried again without the $

i think the issue is that i wrote “A:H” instead of “A1:H1000” for some reason the second work and not the first

thank you

12

thank you jose

my excel is on sharepoint though not on local