Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Spreadsheet::XLSX date format problemby Anonymous Monk |
on Jul 11, 2014 at 14:21 UTC ( [id://1093231]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Hi there Monks! I am using Spreadsheet::XLSX module to read the data from a .xlsx(spreadsheet) file. Source file value : 10/23/2013 The actual data once parsed : 41570 ( The values returned from the cell while reading the data from that cell). It seems to be the number of days since 12/30/1899? Is this a bug with the module? Is there a way to solve this issue like converting or parsing 41570 days since 12/30/1899 to get 10/23/2013 after I read the date data from the .xlsx file? Here is the code I am using:
Thanks for looking!
Back to
Seekers of Perl Wisdom
|
|