Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Using Win32::OLE and Excel - Tips and Tricks

by monarch (Priest)
on Jul 26, 2005 at 02:46 UTC ( #478057=note: print w/ replies, xml ) Need Help??


in reply to Using Win32::OLE and Excel - Tips and Tricks

I wanted to add a note on PowerPoint, as when I googled for "powerpoint Win32::OLE tutorial" this node was the very top link!

So here is how I've gone about creating a PowerPoint presentation.

First load the modules:

use Win32::OLE; use Win32::OLE::Const 'Microsoft Office'; use Win32::OLE::Const 'Microsoft PowerPoint'; use strict;
..then setting warnings as per the Excel tutorial..
$Win32::OLE::Warn = 3; # die on errors

Next, name the file that will be saved:

my $filename = "c:\\temp\\testpower.ppt";
.. and then fire up the PowerPoint application
print( "Starting Powerpoint Object\n" ); my $power = Win32::OLE->GetActiveObject('Powerpoint.Application') || Win32::OLE->new('Powerpoint.Application', 'Quit');

Create a presentation (much like creating a workbook in Excel)

print( "Creating a presentation\n" ); my $ppt = $power->Presentations->Add(); $ppt->SaveAs($filename);
(and save!).

Create a slide (like creating a worksheet in Excel)

print( "Creating a slide\n" ); my $slide = $ppt->Slides->Add(1, ppLayoutBlank); $ppt->SaveAs($filename);

Insert a picture into my slide

my $pname = 'C:\WINNT\Web\Wallpaper\Fall Memories.jpg'; my $shape = $slide->Shapes->AddPicture( $pname, msoFalse, msoTrue, 20, 1 ); # scale to 50% of original size $shape->ScaleHeight( 0.5, msoTrue, msoScaleFromTopLeft ); $shape->ScaleWidth( 0.5, msoTrue, msoScaleFromTopLeft ); $ppt->SaveAs($filename);

Insert a table

print( "Adding a 4 wide by 3 high table\n" ); my $table = $slide->Shapes->AddTable( 3, 4, 1, 100 ); my $columns = $table->Table->Columns->Count; my $rows = $table->Table->Rows->Count; for ( my $row = 0; $row < $rows; $row++ ) { for ( my $col = 0; $col < $columns; $col++ ) { my $cell = $table->Table->Rows($row+1)->Cells($col+1); my $textframe = $cell->Shape->TextFrame; $textframe->TextRange->{Text} = "$col,$row"; $textframe->TextRange->Font->{Bold} = msoFalse; $textframe->TextRange->Font->{Name} = "Arial"; # set text size AFTER changing text $textframe->TextRange->Font->{Size} = "12"; } } $ppt->SaveAs($filename);

There's a lot more that can be done, of course, and the best reference is at MSDN's Visual Basic Reference for PowerPoint. All the methods and properties used here are listed there. In addition, when calling a method, you often can leave parameters off the end and defaults will be used for you.

Another note to add.. if you're not running PowerPoint at the time this script is run, then it will happen in the background. The only way to know for sure if it worked is to open the file you created and visually verify everything was added.


Comment on Re: Using Win32::OLE and Excel - Tips and Tricks
Select or Download Code
Re^2: Using Win32::OLE and Excel - Tips and Tricks
by rlewis (Initiate) on Apr 22, 2007 at 00:11 UTC
    Bareword "msoFalse" "msoTrue" "msoScaleFromTopLeft" not allowed while "strict subs" in use at PPT_ex_2.pl line 25. How can I use the MSWin32 constants without a reference? Thanks...
      I'm seeing the problem with MSWin32 constants and 'use strict'. Anyone know what the problem is ? Any workaround? Thanks, -- Charles DeRykus
        I needed to add the following to get the needed constant def's: use Win32::OLE::Const 'Microsoft Office .* Object Library'; Sorry for the noise.. -- Charles DeRykus
Re^2: Using Win32::OLE and Excel - Tips and Tricks
by katsomo (Initiate) on Jun 04, 2013 at 14:29 UTC
    thank ou for sharing the way to handle poewrpoint through perl....i am a beginner in perl and i am trying to display an image on the slide but i am geting the same error as mentioned in the first comment...could you please elaborate on it ?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://478057]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2014-10-30 23:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (211 votes), past polls