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
|
#!/usr/bin/env perl
use strict;
use warnings;
use Test::More;
use Spreadsheet::ParseXLSX;
my %tests = (
A1 => [0, 0],
Z3 => [2, 25],
AA5 => [4, 26],
IV256 => [255, 255],
ZZ10 => [9, 701],
AAA8 => [7, 702],
XFD22 => [21, 16383],
);
for my $cell (sort keys %tests) {
# XXX not public API, but i'm lazy
is_deeply(
[ Spreadsheet::ParseXLSX->_cell_to_row_col($cell) ],
$tests{$cell},
"correct value for $cell"
);
}
done_testing;
|