add image in a specific cell

padawan_linuxero has asked for the wisdom of the Perl Monks concerning the following question:

Dear monks I have a problem in a report I need to add an image of a barcode, the thing is that when I try to do this

$Hoja -> Range("E47")->Select();
$Excel->ActiveSheet->Pictures->Insert('c:\projectword\1.jpg');
[download]

is putting the image way up like in the B7 or something like that, my question is how can I tell Perl to put the image in E47??? thank you please this is urgent

Comment on add image in a specific cell Download Code

Replies are listed 'Best First'.
Re: add image in a specific cell by olus (Curate) on Feb 29, 2008 at 16:18 UTC
What module are you using? Spreadsheet::WriteExcel has a `insert_image($row, $col, $filename, $x, $y, $scale_x, $scale_y)` method.	[reply] [d/l]
Re^2: add image in a specific cell by padawan_linuxero (Scribe) on Feb 29, 2008 at 16:31 UTC
Hi !!! I am using WIN32::OLE only, can I combine both modules?	[reply]
Re^3: add image in a specific cell by olus (Curate) on Feb 29, 2008 at 17:52 UTC
I tried your code and it worked. Just to make sure, have you called `Activate` on your `$Hoja`? Like: `$Hoja = $workbook->>Worksheets(1); $Hoja->Activate();` [download]	[reply] [d/l] [select]
Re^4: add image in a specific cell by padawan_linuxero (Scribe) on Feb 29, 2008 at 18:30 UTC
Re^5: add image in a specific cell by olus (Curate) on Feb 29, 2008 at 18:45 UTC
Some notes below your chosen depth have not been shown here