How to insert images to excel sheet?

Hi, all

I have a lot of images and need to be inserted into different cells.

Beside open target excel file, and set images to clipboard and paste to cell, do you have any other easy ways to do that?

And I have tried to use the package ‘balareva.excel.activity’ ‘insert image at cell’, it did not working and threw an error:
Insert Image At Cell: Unable to cast object of type ‘System.Double’ to type ‘System.Single’.
I tried to convert arguments to ‘System.Single’, or to create a variant which type is ‘System.Single’, but still got same error.

Hhm, hope to get your news.

Hi @maxzz

Please check below thread

Regards,

Hi @maxzz

You can Excel macro approach to add images to specific cells, I have explained it in the below post by using invoke VBA activity.

Hope this helps :slight_smile:

I knew this method, it’s working, but I still want to find some other way which is more simple