Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Setting format in Excel using perl

by Tux (Abbot)
on Apr 06, 2018 at 12:15 UTC ( #1212436=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $wbk = Spreadsheet::WriteExcel->new ($xls);
    my $wks = $wbk->add_worksheet ();
    my $fmt = $wbk->add_format (align => "center", num_format => "dd-mm-yy
    +yy");
    $wks->write ($row, $col, $date, $fmt);
    
  2. or download this
    use Spreadsheet::WriteExcel;
    use Date::Calc qw( Delta_Days );
    ...
    $wks->write_date_time ("D2", "2018-04-06T16:17", $dtf);
    
    $wbk->close;
    

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (1)
As of 2020-10-25 03:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (248 votes). Check out past polls.

    Notices?