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
|
|---|
| 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 |