in reply to Spreadsheet::XLSX date problem

$ perl -MDate::Simple=date -wle 'print date("2009-11-18") - 40135' 1899-12-30

So it seems to count the days since a date close to 1900-01-01. Maybe that helps you to turn the integers back into dates.

I know that Spreadsheet::ParseExcel has the ChkType method which would tell you if a given piece of data is a date, no idea if Spreadsheet::XLSX provides similar information...

Perl 6 - links to (nearly) everything that is Perl 6.