| 1 |
#!/usr/bin/perl |
| 2 |
|
| 3 |
use 5.014000; |
| 4 |
use warnings; |
| 5 |
|
| 6 |
our $VERSION = "0.03"; |
| 7 |
our $CMD = $0 =~ s{.*/}{}r; |
| 8 |
|
| 9 |
sub usage { |
| 10 |
my $err = shift and select STDERR; |
| 11 |
print "usage: $CMD [--verbose[=1]] file.xls file.xlsx\n"; |
| 12 |
exit $err; |
| 13 |
} # usage |
| 14 |
|
| 15 |
use Spreadsheet::Read; |
| 16 |
use List::Util qw( max ); |
| 17 |
use Getopt::Long qw(:config bundling); |
| 18 |
GetOptions ( |
| 19 |
"help|?" => sub { usage (0); }, |
| 20 |
"V|version" => sub { print "$CMD [$VERSION]\n"; exit 0; }, |
| 21 |
|
| 22 |
"ccdiff!" => \ my $opt_cc, |
| 23 |
|
| 24 |
"v|verbose:2" => \(my $opt_v = 1), |
| 25 |
) or usage (1); |
| 26 |
|
| 27 |
my $file1 = shift or usage (1); |
| 28 |
my $file2 = shift or usage (1); |
| 29 |
|
| 30 |
binmode STDOUT, ":encoding(utf-8)"; |
| 31 |
|
| 32 |
my $ss1 = Spreadsheet::Read->new ($file1) or die "Cannot read $file1: $!\n"; |
| 33 |
my $ss2 = Spreadsheet::Read->new ($file2) or die "Cannot read $file2: $!\n"; |
| 34 |
|
| 35 |
say for $ss1->sheets; |
| 36 |
if ($opt_cc) { |
| 37 |
require App::ccdiff; |
| 38 |
$@ || $App::ccdiff::VERSION lt "0.29" and |
| 39 |
die "App::ccdiff-0.29 or higher required for --cc\n" |
| 40 |
} |
| 41 |
|
| 42 |
print "< $file1\t(", scalar $ss1->sheets, " sheets)\n"; |
| 43 |
print "> $file2\t(", scalar $ss2->sheets, " sheets)\n"; |
| 44 |
foreach my $s (1 .. max map { scalar $_->sheets } $ss1, $ss2) { |
| 45 |
my $s1 = $ss1->sheet ($s); |
| 46 |
my $s2 = $ss2->sheet ($s); |
| 47 |
unless ($s1) { |
| 48 |
print "$s: not in $file1\n"; |
| 49 |
last; |
| 50 |
} |
| 51 |
unless ($s2) { |
| 52 |
print "$s: not in $file2\n"; |
| 53 |
last; |
| 54 |
} |
| 55 |
|
| 56 |
printf "Sheet %d\n\t< %5d x %5d %s\n\t> %5d x %5d %s\n", $s, |
| 57 |
$s1->maxcol, $s1->maxrow, $s1->label, |
| 58 |
$s2->maxcol, $s2->maxrow, $s2->label; |
| 59 |
|
| 60 |
if ($opt_cc) { |
| 61 |
my @c; |
| 62 |
foreach my $ss ($s1, $s2) { |
| 63 |
push @c => [ map { join ("|" => @$_) . "\n" } |
| 64 |
[ map { $ss->col2label ($_) } 1 .. $ss->maxcol ], |
| 65 |
map { [ $ss->row ($_) ] } 1 .. $ss->maxrow ]; |
| 66 |
} |
| 67 |
|
| 68 |
App::ccdiff::ccdiff (@c, { header => 0, unified => 3, "utf-8" => 1 }); |
| 69 |
next; |
| 70 |
} |
| 71 |
|
| 72 |
my $mc = max map { $_->maxcol } $s1, $s2; |
| 73 |
foreach my $r (1 .. max map { $_->maxrow } $s1, $s2) { |
| 74 |
if ($r > $s1->maxrow) { |
| 75 |
print "$s: EOS in $file1 at row $r\n"; |
| 76 |
last; |
| 77 |
} |
| 78 |
if ($r > $s2->maxrow) { |
| 79 |
print "$s: EOS in $file2 at row $r\n"; |
| 80 |
last; |
| 81 |
} |
| 82 |
my @r1 = $s1->row ($r); |
| 83 |
my @r2 = $s2->row ($r); |
| 84 |
foreach my $c (1 .. $mc) { |
| 85 |
my $c1 = $r1[$c]; |
| 86 |
my $c2 = $r2[$c]; |
| 87 |
if (defined $c1) { |
| 88 |
if (defined $c2) { |
| 89 |
$c1 eq $c2 and next; |
| 90 |
print "$s: ($r, $c)\n\t< $c1\n\t> $c2\n"; |
| 91 |
next; |
| 92 |
} |
| 93 |
print "$s: ($r, $c)\n\t< $c1\n\t> -- undefined --\n"; |
| 94 |
next; |
| 95 |
} |
| 96 |
defined $c2 or next; |
| 97 |
print "$s: ($r, $c)\n\t< -- undefined --\n\t> $c2\n"; |
| 98 |
} |
| 99 |
} |
| 100 |
} |