Help for this page

Select Code to Download


  1. or download this
        my $bottomRight = (split (/:/, $self->worksheet->UsedRange->addres
    +s(0,0)))[-1];
        my ($colNameMax, $rowNumMax) = $bottomRight =~ /^([A-Z]+)(\d+)/;
        $self->lastRow( $rowNumMax );
        $self->maxCol( $colNameMax );
    
  2. or download this
    my $rowData = $sheet->Range("A$row:" . $self->maxCol . $row)->{Value};
    
  3. or download this
    foreach my $value (ref $rowData ? reverse @{ $rowData->[0] } : $rowDat
    +a) {
    
  4. or download this
    my $fn = eval "sub {
        my \@F = \@_;
        no warnings 'uninitialized';
        $perlCode
    }";
    die $@ if $@;