Re: Setting format in Excel using perl


There's more than one way to do things
	PerlMonks

Re: Setting format in Excel using perl

by afoken (Chancellor)

on Apr 06, 2018 at 12:08 UTC ( [id://1212434]=note: print w/replies, xml )

Need Help??

in reply to Setting format in Excel using perl

Show the relevant part of your code. Which module do you use to generate the Excel file?

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Comment on Re: Setting format in Excel using perl

Replies are listed 'Best First'.

Re^2: Setting format in Excel using perl
by jsuresh (Acolyte) on Apr 06, 2018 at 12:13 UTC

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++;
}
[download]

2018-04-11 Athanasius added code tags

[reply]
[d/l]

In Section Seekers of Perl Wisdom