#!/usr/bin/env perl
use strict;
use warnings;
use Test::More;
use Spreadsheet::ParseXLSX;
my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/bug-6-2.xlsx');
is($wb->worksheet_count, 9);
my %cells = (
7 => {
0 => "acr business objects users",
1 => "MBX or Distribution group",
},
8 => {
0 => "atst",
1 => "Kevin Krause; Gale Wilson",
},
9 => {
0 => "cts tracking research",
1 => "Theresa Kreckman; Jamie Engle",
},
10 => {
0 => "docs ddm",
1 => "Marc Barney; Everett Music",
},
11 => {
0 => "docs read only",
1 => "Marc Barney; Everett Music; Theresa Kreckman; Jamie Engle",
},
12 => {
0 => "distwhl3rdparty",
1 => "Theresa Kreckman; Jamie Engle",
},
13 => {
0 => "ent logis b2b",
1 => "Mark Reed; Mark Teschner",
},
14 => {
0 => "ent qamasterx",
1 => "Margaret Davis; Ron Medinger",
},
15 => {
0 => "ent shipments",
1 => "Jamie Engle; Teresa Kreckman",
},
16 => {
0 => "ful distrib plan",
1 => "Theresa Kreckman",
},
17 => {
0 => "ful traffic share",
1 => "Mark Reed; Mark Teschner",
},
18 => {
0 => "ful",
1 => "Mark Teschner",
},
19 => {
0 => "hwc_international",
1 => "Kelly Simmons",
},
20 => {
0 => "masterpack/lotships",
1 => "MBX or Distribution group",
},
21 => {
0 => "medford distribution planning - mbx access",
1 => "MBX or Distribution group",
},
22 => {
0 => "nph fruit team minutes",
1 => "MBX or Distribution group",
},
23 => {
0 => "odd costco",
1 => "Theresa Kreckman; Jamie Engle",
},
24 => {
0 => "odd qvc",
1 => "Theresa Kreckman; Jamie Engle",
},
25 => {
0 => "opr ctsdata",
1 => "Theresa Kreckman; Jamie Engle",
},
26 => {
0 => "opr selectinterface",
1 => "Jamie Engle; Theresa Kreckman",
},
27 => {
0 => "opr worldship",
1 => "Chris Larson; Jamie Engle",
},
28 => {
0 => "opr-dropship",
1 => "Theresa Kreckman; Carolyn Townsend",
},
29 => {
0 => "opr-ship docks info",
1 => "Chris Larson; Pam Saxbury",
},
30 => {
0 => "opr-shipoutbol",
1 => "Mark Reed; Mark Teschner; Theresa Kreckman",
},
31 => {
0 => "proxy internet",
1 => "Chris Works",
},
32 => {
0 => "sap users",
1 => "MBX or Distribution group",
},
33 => {
0 => "trailertracking",
1 => "Theresa Kreckman; Everett Music; Jamie Engle",
},
34 => {
0 => "vendorunitaccess",
1 => "Carolyn Townsend; Everett Music; Theresa Kreckman",
},
35 => {
0 => "wms dist",
1 => "MBX or Distribution group",
},
);
my $ws = $wb->worksheet('DSGroups');
for my $row (sort { $a <=> $b } keys %cells) {
for my $col (sort { $a <=> $b } keys %{ $cells{$row} }) {
my $cell = $ws->get_cell($row, $col);
next unless $cell;
is($cell->value, $cells{$row}{$col}, "correct value for ($row, $col)");
}
}
done_testing;