How to transfer data from excel to powerpoint using Perl?

Question

I am using Active Perl from ActiveState and would like to to transfer data from an Excel sheet to a particular table on the slides in a particular Power point file.

How do I do it in Perl?

it would include read data from excel sheet(column wise), process it and idsplay the same in a perticular slide in ppt. — user2111195, Mar 06 '13 at 06:08
if you are on windows, better do it in vba or powershell. Both source and target are MS products — knb, Mar 06 '13 at 13:20

wsdookadr · Answer 1 · 2013-03-08T10:23:05.547

0

I suggest you call your Perl script from VBA.

You can do that like this(in VBA):

ShellWait "c:\perl\bin\perl.exe c:\path\to\script.pl", vbNormalFocus

Also try the Shell API that VBA provides.

UPDATE

I suggest you write to disk first(in Excel). And then you read from disk(in Powerpoint). And you do this using VBA, both of these. Using Perl for this makes little sense because you're going to get wrapped up into file parsing problems and all sorts of other stuff.

edited Mar 08 '13 at 10:23

answered Mar 06 '13 at 12:33

wsdookadr

2,584
1
21
44

i am looking for the perl code to transfer the data from excel to a specific slide on a ppt....kindly help me with it. – user2111195 Mar 08 '13 at 09:57
I suggest you write to disk first(in Excel). And then you read from disk(in Powerpoint). And you do this using VBA, both of these. Using Perl for this makes little sense because you're going to get wrapped up into file parsing problems and all sorts of other stuff. – wsdookadr Mar 08 '13 at 10:22

How to transfer data from excel to powerpoint using Perl?

1 Answers1