Debian Codegraph @

scripts/ssdiff

raw
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 }