in reply to Setting format in Excel using perl
Hi,
I'm trying to fetch the data from database using the query and then print it into excel. so,for that, we need to set format for the field dynamically. I've tried all the cases but it is not working.I'm sharing the part of the code.
Please look through it and support.my $row2=1; while(my @field=$sth2->fetchrow_array){ my $col2=0; my $arr_ref=\@field; # print "$field[19]\n";--> This is my field and this is + where I need to set the custom format. $worksheet2->write_row($row2,0,$arr_ref); $row2++; }
2018-04-11 Athanasius added code tags
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Setting format in Excel using perl
by poj (Abbot) on Apr 10, 2018 at 10:01 UTC | |
by jsuresh (Acolyte) on Apr 11, 2018 at 06:56 UTC | |
by poj (Abbot) on Apr 11, 2018 at 10:36 UTC | |
by jsuresh (Acolyte) on Apr 11, 2018 at 13:24 UTC | |
by poj (Abbot) on Apr 11, 2018 at 13:42 UTC | |
|
In Section
Seekers of Perl Wisdom