Help for this page

Select Code to Download


  1. or download this
    XLSperl -lane 's/fubar/foobar/ for(@F); XLSprint @F' < old.xls > new.x
+ls
  2. or download this
    XLSperl -lne '$h{"$WS:$CELL: $_"}++;END{print for(grep {$h{$_}==1} key
+s %h)}' old.xls new.xls
  3. or download this
    XLSperl -lne '$h{"$WS:$CELL:$_"}.="in $ARGV";
  END{print "$_ ($h{$_})" for(grep{$h{$_}!~/\.xlsin /}sort keys %h)}' 
+a.xls b.xls