Help for this page

Select Code to Download

Select or download this

my $format = $workbook->add_format(num_format => 'mm/dd/yy');
$worksheet->write_date_time(0, 1, '2004-05-13', $format); # wrong
$worksheet->write_date_time(1, 1, '2004-05-13T', $format); # right

Select or download this

Row, Col    = (0, 1)
Value       = 2004-05-13

Row, Col    = (1, 1)
Value       = 05/13/04