Create and Embed Objects in excel

tutorial
faq

#1

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)


How to save Screen Shot Image in Excel
Adding Screen shot in excel workbook
How to copy paste an image into an excel file and how to paste those images in different sheets of the same excel?
Paste image to a specific tab of an excel file
How to insert PDF file into Excel file
PrtSc hotkey
Web recording changing UI elements issue
#2

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


#3

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


#4

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


#5

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


#6

Hi,

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


#7

@aksh1yadav @Eesh_Tyagi


#8

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