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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
#!/usr/bin/perl
use strict;
use warnings;
BEGIN { $ENV{SPREADSHEET_READ_XLSX} = "Spreadsheet::ParseXLSX"; }
my $tests = 266;
use Test::More;
require Test::NoWarnings;
use Spreadsheet::Read;
Spreadsheet::Read::parses ("xlsx") or
plan skip_all => "Cannot use $ENV{SPREADSHEET_READ_XLSX}";
my $xls;
ok ($xls = ReadData ("files/attr.xlsx", attr => 1), "Excel Attributes testcase");
SKIP: {
ok (my $clr = $xls->[$xls->[0]{sheet}{Colours}], "colors");
defined $clr->{attr}[2][2]{fgcolor} or
skip "$xls->[0]{parser} $xls->[0]{version} does not reliably support colors yet", 255;
is ($clr->{cell}[1][1], "auto", "Auto");
is ($clr->{attr}[1][1]{fgcolor}, undef, "Unspecified font color");
is ($clr->{attr}[1][1]{bgcolor}, undef, "Unspecified fill color");
my @clr = ( [],
[ "auto", undef ],
[ "red", "#ff0000" ],
[ "green", "#008000" ],
[ "blue", "#0000ff" ],
[ "white", "#ffffff" ],
[ "yellow", "#ffff00" ],
[ "lightgreen", "#00ff00" ],
[ "lightblue", "#00ccff" ],
[ "gray", "#808080" ],
);
foreach my $col (1 .. $#clr) {
my $bg = $clr[$col][1];
is ($clr->{cell}[$col][1], $clr[$col][0], "Column $col header");
foreach my $row (1 .. $#clr) {
my $fg = $clr[$row][1];
is ($clr->{cell}[1][$row], $clr[$row][0], "Row $row header");
is ($clr->{attr}[$col][$row]{fgcolor}, $fg, "FG ($col, $row)");
is ($clr->{attr}[$col][$row]{bgcolor}, $bg, "BG ($col, $row)");
}
}
}
ok ($xls = Spreadsheet::Read->new ("files/attr.xlsx", attr => 1), "Attributes OO");
is ($xls->[1]{attr}[3][3]{fgcolor}, "#008000", "C3 Forground color direct");
is ($xls->sheet (1)->attr (3, 3)->{fgcolor}, "#008000", "C3 Forground color OO rc hash");
is ($xls->sheet (1)->attr ("C3")->{fgcolor}, "#008000", "C3 Forground color OO cell hash");
is ($xls->sheet (1)->attr (3, 3)->fgcolor, "#008000", "C3 Forground color OO rc method");
is ($xls->sheet (1)->attr ("C3")->fgcolor, "#008000", "C3 Forground color OO cell method");
is ($xls->[1]{attr}[3][3]{bogus_attribute}, undef, "C3 bogus attribute direct");
is ($xls->sheet (1)->attr ("C3")->{bogus_attr}, undef, "C3 bogus attribute OO hash");
is ($xls->sheet (1)->attr ("C3")->bogus_attr, undef, "C3 bogus attribute OO method");
unless ($ENV{AUTOMATED_TESTING}) {
Test::NoWarnings::had_no_warnings ();
$tests++;
}
done_testing ($tests);
|
