Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Adding pictures to Excel

by merrymonk (Friar)
on Jan 23, 2010 at 13:03 UTC ( #819178=perlquestion: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #___ INSERT PICTURE
    $sheet -> Pictures -> Insert("picture_name");                # Insert 
    +in upper-left corner
    $excel -> ActiveSheet -> Pictures -> Insert("picture_name"); # Insert 
    +in active cell
    #___ ACTIVATE CELL
    $sheet -> Range("A2") -> Activate;
    
  2. or download this
     
    use OLE;
    use Win32::OLE::Const "Microsoft Excel";
    ...
    $excel -> ActiveSheet -> Pictures -> Insert($image_file_full); # Inser
    +t in active cell
    $cell_id = "F10";
    $excel -> ActiveSheet -> Pictures -> Insert($image_file_full);
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://819178]
Approved by biohisham
Front-paged by davies
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (9)
As of 2014-12-21 18:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (106 votes), past polls