Merge pull request #26 from felliott/parseexcel-parity

Add TabColor and ColFmtNo support to ParseXLSX

4 files changed, 40 insertions, 0 deletions

diff --git a/t/column-formats.t b/t/column-formats.t
new file mode 100644
index 0000000..7ce9650
--- /dev/null
+++ b/t/column-formats.t
@@ -0,0 +1,25 @@
+#!/usr/bin/env perl
+use strict;
+use warnings;
+use Test::More;
+
+use Spreadsheet::ParseXLSX;
+
+my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/column-formats.xlsx');
+my $ws = $wb->worksheet(0);
+
+ok(my $col_format_nos = $ws->{ColFmtNo});
+
+my @col_formats = map { $wb->{Format}[ $_ ] } @$col_format_nos;
+is_deeply($col_formats[0]->{Fill}, [1, '#FF0000', '#FFFFFF']);
+
+is($col_formats[1]->{AlignH}, 3);
+is($col_formats[1]->{AlignV}, 0);
+
+my $font = $col_formats[2]->{Font};
+is_deeply($font->{Name}, 'Arial');
+is_deeply($font->{Height}, 16);
+is_deeply($font->{Bold}, 1);
+
+
+done_testing;
diff --git a/t/data/column-formats.xlsx b/t/data/column-formats.xlsx
new file mode 100644
index 0000000..a1a9344
--- /dev/null
+++ b/t/data/column-formats.xlsx
diff --git a/t/data/tab-color.xlsx b/t/data/tab-color.xlsx
new file mode 100644
index 0000000..7061e84
--- /dev/null
+++ b/t/data/tab-color.xlsx
diff --git a/t/tab-color.t b/t/tab-color.t
new file mode 100644
index 0000000..ef1ab49
--- /dev/null
+++ b/t/tab-color.t
@@ -0,0 +1,15 @@
+#!/usr/bin/env perl
+use strict;
+use warnings;
+use Test::More;
+
+use Spreadsheet::ParseXLSX;
+
+my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/tab-color.xlsx');
+my $ws1 = $wb->worksheet(0);
+is($ws1->get_tab_color, '#FF0000');
+
+my $ws2 = $wb->worksheet(1);
+is($ws2->get_tab_color, undef);
+
+done_testing;