Help for this page

Select Code to Download


  1. or download this
    my $retrieve_ref = $sbh->fetchall_arrayref;
    for (my $count = 0; $count < @$retrieve_ref; $count++) {
        $sheet->Range("A$count:B$count")->{Value} = $$retrieve_ref[$count]
    +;
    }
    
  2. or download this
    {
        package WakkaWakka;
    ...
        sub Range {$_[0]->SUPER::Range("A$_[1]:B$_[1]");}
        bless $sheet, __PACKAGE__;
    }
    
  3. or download this
    $sheet->Range($count)->{Value} = $$retrieve_ref[$count];