Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Re: read-excel.pl: a code sample for Spreadsheet::ParseExcel

by da (Friar)
on Nov 07, 2002 at 19:47 UTC ( #211201=note: print w/replies, xml ) Need Help??


in reply to Re: read-excel.pl: a code sample for Spreadsheet::ParseExcel
in thread read-excel.pl: a code sample for Spreadsheet::ParseExcel

As far as I know, you just use Value. What exactly does it output for date cells? When I just ran the above sample code on a linux box, I got a formatted date output where there is a date in the original data (an Excel 2000-formatted spreadsheet).

___ -DA $_='daniel@coder.com 519-575-3733 /Prescient Code Solutions/ coder.c +om ';s/-/ /g;s/([.@])/ $1/g;@y=(42*1476312054+7*3,14120504e4,-42*330261-3 +3, 42*5436+3,42*2886+10,42*434987+5);s/(.)/ord(uc($1))/ge;for(@x=split/32 +/; @y; map{print chr} split /(..)/, shift(@x) + shift(@y)) {perlmonk.da.r +u}

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (5)
As of 2020-01-23 22:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?