Copy slides from ppt & paste it as an image in excel sheet.

I'm using MATLAB to handle 2 different files (.ppt & .xls). I want to copy the slide from .ppt file and paste it as an image in the excel sheet. I tried to use following code:

ppt = actxserver('Powerpoint.Application');
myppt = ppt.Presentations.Open(filename);
slides = myppt.Slides;
cpy = slides(1).Copy;

The last line does not execute. I tried using 'Duplicate' as well, but that does not work as well. Can anyone help me with this problem?

Answer 1

[Geetla Sindhu]

Hello Himanshu,

I understand that you are trying to copy the slide from .ppt file and paste in an excel sheet.

You can try the workaround provided below to solve the issue:

% Create an ActiveX object
>> ppt = actxserver('powerpoint.application');
>> ppt.Visible = 1;
% Open an existing presentation by supplying the full path to the file
>> myppt = ppt.Presentations.Open('C:\MyFolder\test.ppt');
% Slides
>> slides = myppt.Slides;
% Select a slide
>> slide = slides.Item(1); 
>> cpy = slide.Duplicate;

This code will create a copy of the slide which you want to paste in the excel sheet.

You can refer to the below documentation to paste the image into an excel sheet.

• How to save an image loaded in matlab in excel? file - MATLAB Answers - MATLAB Central (mathworks.com)
• Writing MATLAB image to Excel file at a specific position - MATLAB Answers - MATLAB Central (mathworks.com)

Thank you.

[Himanshu Verma]

Thank you.