Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Setting format in Excel using perl

by afoken (Canon)
on Apr 06, 2018 at 12:08 UTC ( #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". ;-)

Replies are listed 'Best First'.
Re^2: Setting format in Excel using perl
by jsuresh (Novice) 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++; }

    2018-04-11 Athanasius added code tags

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1212434]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2020-10-01 23:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (25 votes). Check out past polls.

    Notices?