How to input images into excel cells?

Is there a way input images into specific cells in excel? I have about 100 images that I would like to put in an excel file that currently has other information related to the images.

Answer 1

[ES]

You should use activeX (https://in.mathworks.com/help/matlab/matlab_external/using-a-matlab-application-as-an-automation-client.html) You can copy the image to clipboard and use activex excel control to paste it.

      ActiveSheet.Paste
      ActiveSheet.Shapes.Range(Array("Picture 1")).Select
      ActiveWindow.ScrollRow = 2
      ActiveWindow.ScrollRow = 1
      Selection.ShapeRange.ScaleWidth 0.1552734375, msoFalse, msoScaleFromTopLeft
      Selection.ShapeRange.ScaleHeight 0.1552734322, msoFalse, msoScaleFromTopLeft

Answer 2

[Jan]

Did you take the time to ask an internet search engine at first? This is easier and faster than letting the forum post the corresponding links:

• https://www.mathworks.com/matlabcentral/answers/91547-how-do-i-insert-a-matlab-figure-into-an-excel-workbook-through-activex
• http://de.mathworks.com/matlabcentral/fileexchange/51191-img2xlsx
• https://stackoverflow.com/questions/7779880/insert-image-in-excel-through-matlab?rq=1
• etc.