Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
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 romping around the Monastery: (3)
As of 2014-08-21 04:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (127 votes), past polls