How to find TEXT in excel

[vineelag (vineetha)]

Hi all,

I have a text in excel sheet i need to find the inside text.
By using which activities or logic i can use to achieve this text inside this box.

Please referee given attachment

I need to find the box inside the text “LED information：”

Thank you!!!

[ashokkarale]

@vineelag,

You will have to use Ui Automation for this. Use Get Text Activity to get this.

Sample code here:

Code File:
AddQueueItem Demo.xaml (12.0 KB)

Excel File:

Book1.xlsx (9.4 KB)

Output:

Thanks,
Ashok

[vineelag (vineetha)]

Hi @ashokkarale

but i already build logic in classic activities, can you suggest me in classic activities.

Thank you @ashokkarale

[ashokkarale]

@vineelag, you can use classic get text activity in that case.

[vineelag (vineetha)]

HI @ashokkarale

the file which your shared with me is not opening

Thank you!!!

[ashokkarale]

Read Text Demo.zip (12.7 KB)

@vineelag, Here is full project to refer.

[vineelag (vineetha)]

Hi @ashokkarale

while try to open getting like this

and main file is empty

[ashokkarale]

@vineelag,

That’s weird. Here I have copy pasted the activities in Main workflow as well.

Extract the project to some folder and then Open it.

Read Text Demo.zip (15.1 KB)

Thanks,
Ashok

[vineelag (vineetha)]

Hay @ashokkarale

[ashokkarale]

@vineelag,

It’s developed in Studio 2024.4.0 community version. Do you have lower version than this?

This could be the only reason you are facing this issue while opening the code.

If not able to open the code, refer this code snippet. All properties are default.

Thanks,
Ashok