<?xml version="1.0" encoding="windows-1252"?>
<node id="788736" title="Reading excel file using PERL" created="2009-08-14 15:56:43" updated="2009-08-14 15:56:43">
<type id="115">
perlquestion</type>
<author id="961">
Anonymous Monk</author>
<data>
<field name="doctext">
I'm using Perl to parse through an Excel file and I'm having trouble with a date field. The date displays as 8/14/2009 (mm/dd/yyyy)but when the script runs it is printing as "Win32::OLE::Variant=SCALAR(0x2626704)" for value and 36756 for formula.  Is there any way to read the date field and print it as date format (dd/mm/yyyy)?
</field>
<field name="reputation">
4</field>
</data>
</node>
