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.

Hi Askhay,

Thank you for sharing this, however could you please help me with steps where we can attach an object to excel without opening excel (Backend).

Regards,
Abhinav