Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Setting format in Excel using perl

by Tux (Canon)
on Apr 06, 2018 at 12:15 UTC ( [id://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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1212436]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (6)
As of 2024-03-29 11:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found