Does anyone know how to fill in a Powerpoint table with MATLAB? I can
do program everything else I need it to do but when I use the Cell
method I get an error stating "??? No appropriate method, property, or
field Selection for class
Interface.Microsoft_PowerPoint_12.0_Object_Library.Shape."

My code is

PPT = actxserver('PowerPoint.Application');
PPT.Visible = true;
PPTpres = invoke(ppt.Presentations,'Add');
Slide1=invoke(PPTpres.Slides,'Add',1,12);
Table1=Slide1.Shapes.AddTable(3, 4, 10, 10, 288, 216);
Table1.Cell(1, 1).Shape.TextFrame.TestRange.Text='test'

I've tried several different variants of the last line and nothing has
worked yet.
Thanks,
Rick

rickcanham <rickcanham@hotmail.com> wrote in message <71a3ac6c-15cd-4262-af0e-ed5e7927b597@33g2000yqo.googlegroups.com>...
> Does anyone know how to fill in a Powerpoint table with MATLAB? I can
> do program everything else I need it to do but when I use the Cell
> method I get an error stating "??? No appropriate method, property, or
> field Selection for class
> Interface.Microsoft_PowerPoint_12.0_Object_Library.Shape."
> 
> My code is
> 
> PPT = actxserver('PowerPoint.Application');
> PPT.Visible = true;
> PPTpres = invoke(ppt.Presentations,'Add');
> Slide1=invoke(PPTpres.Slides,'Add',1,12);
> Table1=Slide1.Shapes.AddTable(3, 4, 10, 10, 288, 216);
> Table1.Cell(1, 1).Shape.TextFrame.TestRange.Text='test'
> 
> I've tried several different variants of the last line and nothing has
> worked yet.
> Thanks,
> Rick

Why don't you use the activex for excel, then import the excel table to powerpoint. I mean excel is very easy to do , and there are lots of documentation on that.

Dear Rick

This works:
Table1.Table.Cell(1,1).Shape.TextFrame.TextRange.text = 'Test'

using the "code complete" (pressing "tab") and functions like get and inspect can help you out on these not-documented features.

There are many reason to NOT go via Excel. For instance, if you open an existing ppt/pptx, the table you create folows any masters in the presentation.

Peter

rickcanham <rickcanham@hotmail.com> wrote in message <71a3ac6c-15cd-4262-af0e-ed5e7927b597@33g2000yqo.googlegroups.com>...
> Does anyone know how to fill in a Powerpoint table with MATLAB? I can
> do program everything else I need it to do but when I use the Cell
> method I get an error stating "??? No appropriate method, property, or
> field Selection for class
> Interface.Microsoft_PowerPoint_12.0_Object_Library.Shape."
> 
> My code is
> 
> PPT = actxserver('PowerPoint.Application');
> PPT.Visible = true;
> PPTpres = invoke(ppt.Presentations,'Add');
> Slide1=invoke(PPTpres.Slides,'Add',1,12);
> Table1=Slide1.Shapes.AddTable(3, 4, 10, 10, 288, 216);
> Table1.Cell(1, 1).Shape.TextFrame.TestRange.Text='test'
> 
> I've tried several different variants of the last line and nothing has
> worked yet.
> Thanks,
> Rick

Hi all,
I have a similar but slightly different problem: I need to update some tables periodically, I don't want to change the format (color, font etc) of existing tables,  only need to update the numbers. I guess this can be done by something similar to   "Table1.Table.Cell(1,1).Shape.TextFrame.TextRange.text = 'Test'"
but how do I get the reference to "Slide1" and "Table1" in the first place?  I'm not creating new slide or table, but try to access existing ones.
Many thanks.

> PPT = actxserver('PowerPoint.Application');
> PPT.Visible = true;
> PPTpres = invoke(ppt.Presentations,'Add');
> Slide1=invoke(PPTpres.Slides,'Add',1,12);
> Table1=Slide1.Shapes.AddTable(3, 4, 10, 10, 288, 216);
> Table1.Cell(1, 1).Shape.TextFrame.TestRange.Text='test'

Replace last line with:
Table1.Table.Cell(2,2).Shape.TextFrame.TextRange.Text = 'test'