How to type into shape in excel sheet

Help Activities
, , , , ,
1

Hello,

I have an excel file where there is an image and a shape in it. What I want to do is type a text in that shape. as shown in the gif below

091

What I did was I open the excel file using the open application activity then use type into activity for the shape. However, it won’t type as shown in the gif below:

101

I enable ClickBeforeTyping property and tried enabling other properties as well but still it wont type. I also try using click and double click activity before Type Into and still fails. Any suggestions or advice to remedy this will greatly be appreciated. Thanks!

2

Hi @kevzki

use Write cell Acitivty to point cell position…

Thanks
Shyam

3

Thank you for your reply. I would like to type into the shape and not in the cell. I tried writing in the cell where the shape is located at but the shape will just cover it and its not proportional to the shape.

4

Hi @kevzki

User Anchor based activity or Element exists activity

i think it will help you…

Thanks
Shyam

5

How will it help? I tried using them but it still didnt let it type into the shape.

6

Hello @kevzki ,

Please try to record the action using App/Web recorder. It will also capture the selectors using an anchor base .

Else if possible plz share the Excel which you are trying to automate

7

Hi @kevzki

Please try VBA and try to write the code to type data into the cell.

Below is the reference of how to use macro’s in UiPath

Thanks

8

I tried but it won’t still let me. here’s the excel file that I’m trying to automate.
Shape.xlsx (105.4 KB)

I’m not trying to type in the cell but in the shape.