Is there a way to embed a .xlsx object in a ppt from matlab script?

9 次查看(过去 30 天)
I am using mlreportgen.ppt to create a simulation results report in Powerpoint. I wrote tabular results to an Excel .xlsx file and later added them into the .ppt using the Table commands. This works fine, except the tabular results are quite large, and I would like to embed the .xlsx as an object. From the Matlab Help, I found a way to import .xlsx object into a Word Document (using mlreportgen.dom, and EmbeddedObject), but I cannot find a way to import it into a PowerPoint Presentation. There is no EmbeddedObject in the mlreportgen.ppt. Can this be done?

回答(1 个)

Ishaan Mehta
Ishaan Mehta 2024-7-8
编辑:Ishaan Mehta 2024-7-8
Hi Aimee,
Since you are unable to add the Excel sheet in your presentation using "mlreportgen.ppt", doing the same using ActiveX controls can help as a workaround.
You can open an existing PowerPoint presentation through MATLAB using the "actxserver" function as illustrated below:
% Define the path to your PowerPoint file and Excel file
pptFilePath = 'presentation.pptx';
excelFilePath = 'excelSheet.xlsx';
% Open PowerPoint application
pptApp = actxserver('PowerPoint.Application');
pptApp.Visible = true;
% Open the PowerPoint presentation
presentation = pptApp.Presentations.Open(fullfile(pwd, pptFilePath));
Then, you can using PowerPoint's ActiveX commands to access the target slide and using the "slide.Shapes.AddOLEObject" method to embed the Excel sheet as an OLE object in the slide.
You can refer to the below documentation for more information:
Hope this helps!

类别

Help CenterFile Exchange 中查找有关 MATLAB Report Generator 的更多信息

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by