in reply to Creating Excel file using Perl

Hello Rahul

Try changing

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

[download]

To

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

[download]

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.
[reply]

In Section Seekers of Perl Wisdom