1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
#!/usr/bin/perl
#######################################################################
#
# A simple example of how to use the Excel::Writer::XLSX module to
# modify shape properties in an Excel xlsx file.
#
# reverse ('(c)'), May 2012, John McNamara, jmcnamara@cpan.org
#
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'shape2.xlsx' );
my $worksheet = $workbook->add_worksheet();
$worksheet->hide_gridlines( 2 );
my $plain = $workbook->add_shape(
type => 'smileyFace',
text => "Plain",
width => 100,
height => 100,
);
my $bbformat = $workbook->add_format(
color => 'red',
font => 'Lucida Calligraphy',
);
$bbformat->set_bold();
$bbformat->set_underline();
$bbformat->set_italic();
my $decor = $workbook->add_shape(
type => 'smileyFace',
text => "Decorated",
rotation => 45,
width => 200,
height => 100,
format => $bbformat,
line_type => 'sysDot',
line_weight => 3,
fill => 'FFFF00',
line => '3366FF',
);
$worksheet->insert_shape( 'A1', $plain, 50, 50 );
$worksheet->insert_shape( 'A1', $decor, 250, 50 );
__END__
|
