How to specify range in Read Range

Help Activities
, ,
1

How to specify range in updated Read Range activity? Range is type UiPath.Excel.IReadRangeRef. My aim is to read the full range and my project is in c#.

2

Hi @ext-o

If you want to read the entire Sheet then use the below syntax in Excel Read Range activity:
Excel.Sheet["Sheet1"]

If you read a specific Range in a sheet, then you can specify like below:
Excel.Sheet["Sheet1"].Range["A1:C10"]

MicrosoftTeams-image
MicrosoftTeams-image832×892 38.2 KB

Regards

4 Likes
3

Hi @ext-o ,

You can use the + and indicate the range of cells inside excel and hit the tick when you are done selecting.

Hope it helps.

Thanks,
Gautham.

1 Like
4

Thank you for quick help… I checked both methods and they seem to work :100:…

I got another question… My excel contains some icons and get this error:
image

I cannot control the icon names… I tried with executing VBA snippet with Invoke VBA that deletes all pictures from my excel, but then there appears that “enable Trustcenter issue”, which I cannot control either - since the excel is supposed to be downloaded by an automation :man_shrugging: How to get pass that error?

5

Hi @ext-o ,

If it is a pop up , you can use a on element appears activity configure to the pop up that appears and you can use a click activity to click on a option from the pop up.

Make sure to keep the selectors you are using doesn’t contain any static values which might vary from session to session.

On element appears will make sure when the pop up appears the click is carried out.

You can add a delay betwen the open file and on element appears to make sure the pop up gets some time to load you can increase or decrease the delay once you know how much time it takes to launch excel and for the file to open up.

Hope this helps.

6

Hi @ext-o

Check the below thread

Make sure you don’t have image holders in the excel.

Regards