Create and Embed Objects in excel

We can create and embed objects like (.pdf, images, another excel sheets etc) in excel using hot keys automation.

Flow

Go to insert tab --> ALT + N

Click on Text --> Key ZT

Click on create Object --> Key J

Click on create fro file – using click activity

Click on Link to file --> ALT + L(Select Send window messages)

Click on Display as Icon --> ALT + A (Select Send window messages)

Attaching the workflow.

excelObject.zip (252.8 KB)

5 Likes

HI @Eesh_Tyagi

Good Sharing :slight_smile: :clap: :+1:

Here i just have removed the selector and made file path dynamic to read the current directory so others will find it easy to run , Once again nice and useful sharing :slight_smile:

excelObject_Modified.zip (253.9 KB)

Regards…!!
Aksh

6 Likes

Hi @aksh1yadav,

I am getting error SelectorNotFoundException.Could you please look into it.

Main has thrown an exception

Source: Click on ‘Create from file’

Message: Click on ‘Create from file’ : Cannot find the UI element corresponding to this selector:

Exception Type: SelectorNotFoundException

Regards,
Sumit

It is a selectors problem basically. check with UIExplorer :slight_smile:

Hello,
alt +N action is not working for after opening the excel by excel application scope.
Can you please help me ?

Hi,

Is it possible to specify the cell in which we want to embed?

@aksh1yadav @Eesh_Tyagi

Great sharing.
But I have seen this approach before with workflow attached
:stuck_out_tongue:

any solution for huge MB size as from front end if file size is high than it is hanged.