Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^3: Setting format in Excel using perl

by jsuresh (Novice)
on Apr 11, 2018 at 06:56 UTC ( #1212657=note: print w/replies, xml ) Need Help??


in reply to Re^2: Setting format in Excel using perl
in thread Setting format in Excel using perl

Hi Poj,

Everything look's perfect but the only thing is my Perl library is not having the Excel::Writer::XLSX::Utilities module.

I have asked my manager for approving my request to add the module and i will try and will let you know.

Many Thanks, Jey

  • Comment on Re^3: Setting format in Excel using perl

Replies are listed 'Best First'.
Re^4: Setting format in Excel using perl
by poj (Abbot) on Apr 11, 2018 at 10:36 UTC
      Yes,currently I'm using Spreadsheet::WriteExcel.

      Jey

        In that case try the write_date_time solution Tux suggested here

        #!/usr/bin/perl use strict; use Spreadsheet::WriteExcel; use DBI; my $dbh = get_dbh(); # connect as req my $workbook = Spreadsheet::WriteExcel->new( 'perl.xls' ); my $worksheet = $workbook->add_worksheet(); # set column format my $datecol = 19; my $date_format = $workbook->add_format(num_format=>'m/d/yyyy h:mm'); $worksheet->set_column($datecol,$datecol,15,$date_format);#width 15 my $sql = "SELECT * FROM test21"; my $sth = $dbh->prepare($sql); $sth->execute; my $row2 = 1; while (my $aref = $sth->fetchrow_arrayref){ # convert to ISO8601 yyyy-mm-ddThh:mm:ss.ss my $date = $aref->[$datecol]; $date =~ s/ /T/; print "$date\n"; $aref->[$datecol] = ''; $worksheet->write_row($row2,0,$aref); $worksheet->write_date_time($row2,$datecol,$date); ++$row2; } $workbook->close;
        poj

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2020-12-05 18:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (65 votes). Check out past polls.

    Notices?