How to get the cell range using Modern excel activity

Help Studio
, ,
1

How to get the cell range using Modern excel activity .
Example i need hello word cell range i.e A4 as shown in example
image

In classic activities we have lookup range activity to get the cell range , how can we achieve same output using Modern excel activity .

2

maybe you can place some more screenshots

in general we would address like:

Excel.Sheet("YourSheetName").Range("A:A")

UPD1 - Adaptions

3

No actually i have value i.e "Hello " using this i need find the cell range for ex when we go with screen shot its A4
input : Hello
output i need is : A4

4

@anushaanugowda57,

Use Find/Replace Value activity. It Searches in a specified range for a certain value and either returns the address of the cell where it is found or replaces the value with another given value. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Thanks,
Ashok :slight_smile:

5

Hi @anushaanugowda57

You can use Lookup Range activity to get the Exact cell no.

image
image707×621 23.4 KB

Then use write cell if you want to overwrite.

Hope this helps :slight_smile:

6

Thank you @ashokkarale it worked

7

Thank you @AJ_Ask i wanted with modern activities

8

looks like:
grafik

when using UiPath.Excel.Activities 2.23.4

9

@anushaanugowda57,

Glad I’m able to help! Kindly mark my answer as solution.

Thanks,
Ashok :slight_smile:

10

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