<?xml version="1.0" encoding="UTF-8"?><rdf:RDF xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:xlink="http://www.w3.org/1999/xlink/"><rdf:Description rdf:about="http://www.clarkeology.com/m/558/Perl+/+Excel"><dc:date></dc:date><dc:title>Perl / Excel</dc:title><dc:description>Programming idea for the day! Instead of me trying to convince everyone to stop using bloody spreadsheet for everything, and use a system of mine instead, why not modify my systems to read a real excel spreadsheet! It's going to be impossible to conv... </dc:description></rdf:Description><rdf:Description rdf:about="http://www.clarkeology.com/m/559/Perl+and+Excel"><dc:date></dc:date><dc:subject rdf:resource="http://www.clarkeology.com/perl" /><dc:title>Perl and Excel</dc:title><dc:description>Found some handy documentation at &lt;a href=&quot;http://www-106.ibm.com/developerworks/linux/library/l-pexcel/&quot;&gt;IBM.com&lt;/a&gt; of all places.</dc:description></rdf:Description><rdf:Description rdf:about="http://www.clarkeology.com/m/567/Ongoing+Excel+/+PERL+stuff"><dc:date></dc:date><dc:subject rdf:resource="http://www.clarkeology.com/perl" /><dc:subject rdf:resource="http://www.clarkeology.com/excel" /><dc:subject rdf:resource="http://www.clarkeology.com/work" /><dc:subject rdf:resource="http://www.clarkeology.com/mice" /><dc:title>Ongoing Excel / PERL stuff</dc:title><dc:description>The PERL Excel project is coming along nicely, it takes a long time to parse an Excel file, they're enormous... I've been working with a month's worth of gigs, just in partner venues in the UK, and that comes to about 1.1MB, so I opened it in Excel a... </dc:description></rdf:Description><rdf:Description rdf:about="http://www.clarkeology.com/m/571/How+to+convert+an+Excel+date+to+a+UNIX+date"><dc:date></dc:date><dc:subject rdf:resource="http://www.clarkeology.com/perl" /><dc:subject rdf:resource="http://www.clarkeology.com/excel" /><dc:subject rdf:resource="http://www.clarkeology.com/date" /><dc:subject rdf:resource="http://www.clarkeology.com/unix" /><dc:title>How to convert an Excel date to a UNIX date</dc:title><dc:description>Excel stores a date as the number of days since the start of 1900, and UNIX as the number of seconds since the start of 1970, so the sum is:&lt;br /&gt;&lt;br /&gt;&lt;code&gt;$unixTime = ( $excelDate - 25569 ) * 24 * 60 * 60;&lt;/code&gt;&lt;br /&gt;&lt;br /&gt;</dc:description></rdf:Description></rdf:RDF>
