in reply to Re: Setting format in Excel using perl
in thread Setting format in Excel using perl
This is one of the formats I used
my $format1=$workbook->add_format(); $format1->set_bold(); //query my $sth1 = $dbh->prepare($sql1); $sth1->execute(); # write the data into worksheet my $row1=1; while(my @field=$sth1->fetchrow_array){ my $arr_ref=\@field; $worksheet1->write_row($row1,0,$arr_ref); $row1++; }
2018-04-11 Athanasius added code tags
In Section
Seekers of Perl Wisdom