Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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 cooling their heels in the Monastery: (3)
As of 2014-07-26 15:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (178 votes), past polls