WIN32::OLE problem while reading the date format

2006-02-08 Thread swayam panda
Hi ALL, I am reading some values from the Excel file by using Win32::OLE,I am able to read all fields bur not able able read if the date is in dd/mm/yy( i.e / slash) .If i am using backward slash then the date is working .Can any body tell me how to read the a date from the EXCEL

Re: WIN32::OLE problem while reading the date format

2006-02-08 Thread Alfred Vahau
See Win32::OLE::Variant on ActiveState Perl Documentation on how to read the date correctly. Alfred, swayam panda wrote: Hi ALL, I am reading some values from the Excel file by using Win32::OLE,I am able to read all fields bur not able able read if the date is in dd/mm/yy( i.e /