Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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

by thanos1983 (Parson)
on Feb 19, 2019 at 10:33 UTC ( [id://1230157]=note: print w/replies, xml ) Need Help??


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 (Beadle) 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1230157]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2024-04-23 13:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found