Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2017-08-23 21:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Who is your favorite scientist and why?



























    Results (359 votes). Check out past polls.

    Notices?