Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Creating Excel file using Perl

by shadowsong (Monk)
on Oct 20, 2015 at 14:57 UTC ( #1145447=note: print w/replies, xml ) Need Help??


in reply to Creating Excel file using Perl

Hello Rahul

Try changing

my $dateformat = $workbook->add_format(num_format => ~'mm/dd/yyyy~')

To

my $dateformat = $workbook->add_format(num_format => 'mm/dd/yy')

It might be easier for us to investigate and provide further assistance if you posted more of your code..

Replies are listed 'Best First'.
Re^2: Creating Excel file using Perl
by Rahul Saxena (Initiate) on Oct 21, 2015 at 04:11 UTC
    Hello shadowsong, I have tried what you suggested, but format in excel for date values is still showing "custom". how can I display date values in 'date' format in excel. Please help me.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2019-05-20 07:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you enjoy 3D movies?



    Results (123 votes). Check out past polls.

    Notices?