in reply to Excel: is there a way to set a background picture using Perl?

Hello Darkwing,

I know that Spreadsheet::WriteExcel provides a method insert_image($row,-$col,-$filename,-$x,-$y,-$scale_x,-$scale_y) for inserting pictures in the Excel sheet (sample bellow):

#!/usr/bin/perl use strict; use warnings; use Spreadsheet::WriteExcel; # Create a new Excel workbook my $workbook = Spreadsheet::WriteExcel->new('perl.xls'); # Add a worksheet my $worksheet = $workbook->add_worksheet(); # Insert image $worksheet->insert_image('A1', 'perl.png');

I assume that you want specifically to insert an image in the background and not on the foreground.

If this is the case from a quick look up on the Internet I do not think that there is a module in Perl that can do that :(. But maybe I am wrong, maybe another Monk knows a workaround on this.

Never the less if you find a solution it would be nice to update the question so someone else in future can benefit on this.

BR / Thanos

Seeking for Perl wisdom...on the process of learning...not there...yet!

Replies are listed 'Best First'.
Re^2: Excel: is there a way to set a background picture using Perl?
by Darkwing (Scribe) on Feb 21, 2019 at 07:29 UTC
    Hi, i now use the solution from the answer above (Win32::OLE). However, i would consider it to be more convenient if Spreadsheet::WriteExcel also would support adding background pictures.