I am using Excel 2007 and 2010 on PCs using Windows XP.
I use the following Perl to insert Pictures into a spreadsheet.
$image_file_full = <full path to image>
# get a cell in which the image is to be stored
$cell_tg = $sheet->Range($range);
# insert the image
$pic_cur = $sheet->Pictures->Insert($image_file_full);
# position the image in the top left hand corner of the cell
$pic_cur ->{Top}  = $cell_tg->Top;
$pic_cur ->{Left} = $cell_tg->Left;

[download]

This works fine except that if the spreadsheet is sent to another computer the picture is no longer there and I get an error message saying
“The linked image cannot be displayed. The file may have been moved, renamed, or deleted. Verify that the link points to the correct file and location”.
Is there any way the image can be ‘embedded’ in the spreadsheet so that the ‘disappearing’ problem is not found when the spreadsheet is moved from one pc to another?
I know I could send the image as well but I would prefer not to do that since the link would have to be remade.

In reply to Embedding Image in Excell by merrymonk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.