add image in a specific cell

[padawan_linuxero]

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');

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

[olus]

What module are you using? Spreadsheet::WriteExcel has a insert_image($row, $col, $filename, $x, $y, $scale_x, $scale_y) method.

[padawan_linuxero]

Hi !!! I am using WIN32::OLE only, can I combine both modules?

[olus]

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();