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#.

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] Regards

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.

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 ther…

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 ses…

Hi @ext-o Check the below thread [image] Picture names cannot contain any of the following characters: :\/?*[] Studio Well i had to manually check for each picture in the file using the Selection panel. I found out that there was an image place holder with some random na…

How to specify range in Read Range

Help Activities

vrdabberu (Varunraj Dabberu) April 21, 2024, 11:26am 6

Hi @ext-o

Check the below thread

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

Regards

Topic		Replies	Views
Read Studio studio , question , tools	4	934	June 23, 2022
Excel could not read range Automation Cloud	14	1725	May 9, 2022
UiPath.Excel.Activities.ExcelReadRange (Read Range) Studio studio , question , activities_panel	1	170	November 28, 2024
Unable to read range in Excel.Below is the screenshot for the same Help excel , activities , error	2	1077	December 8, 2019
Read range - relationship tag error Studio activities , question	12	490	December 9, 2023

How to specify range in Read Range

Related topics