diff options
Diffstat (limited to 't/bug-6.t')
-rw-r--r-- | t/bug-6.t | 30 |
1 files changed, 30 insertions, 0 deletions
@@ -8,4 +8,34 @@ use Spreadsheet::ParseXLSX; my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/bug-6.xlsx'); is($wb->worksheet_count, 8); +my %cells = ( + 7 => { + 0 => 'mfg fdproc', + 1 => 'Tom Forsythe', + }, + 8 => { + 0 => 'ent bartend-402 data max prodigy max 203 dpi', + 1 => 'Dave Levos ; Tommy Holland', + }, + 9 => { + 0 => 'ent bartend-402 inter px4i 400 dpi rw', + 1 => 'Tommy Holland; Dave Levos', + }, + 10 => { + 0 => 'opr-mfg asmb inst ro', + 1 => 'Chris McGee', + }, +); + +my $ws = $wb->worksheet('DSGroups'); +my ($row_min, $row_max) = $ws->row_range; +my ($col_min, $col_max) = $ws->col_range; +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; |