- 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]
+;
}
- or download this
{
package WakkaWakka;
...
sub Range {$_[0]->SUPER::Range("A$_[1]:B$_[1]");}
bless $sheet, __PACKAGE__;
}
- or download this
$sheet->Range($count)->{Value} = $$retrieve_ref[$count];