Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Adding pictures to Excel

by merrymonk (Hermit)
on Jan 23, 2010 at 13:03 UTC ( [id://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
Domain Nodelet?
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?Last hourOther CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-03-29 08:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found