Ongoing Excel / PERL stuff


Ongoing Excel / PERL stuff

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 and trimmed out all but about 6 lines of it, and it STILL comes to half a meg, insane...

Think we might have MICE in the flat, Clare heard rustling in a cupboard, though it was too dark to investigate (ie I'm putting it off)...

TweetComment / reply

Too many fields appear to be blank

In my ongoing perl / excel investigations, I'm finding that about 5 out of 6 rows appear to have blank info in them, this can't be right can it? Going to learn how to use Data::Dumper so as to investigate the spreadsheets further...
27 Nov TweetComment / reply


Should have checked right away, those lines in the excel file actually were blank... going to work on a few previous months listings now!
28 Nov TweetComment / reply

How to convert an Excel date to a UNIX date

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:

$unixTime = ( $excelDate - 25569 ) * 24 * 60 * 60;

27 Nov TweetComment / reply

Paul Clarke's - I work and live in Hythe near Folkestone, Kent. married to Clare and father to two, I am a code engineer, and I do mostly javascript, nodejs, python, ruby, and php. I like pubbing, restaurants, home automation and other diy jiggery-pokery, history, genealogy, TV, popbitch, squirrels, pirates ☠, lego, and time travel.

Also from the same week

Some more blog posts from the same week as .

Crawler Sending out a crawler today to search Google for things... [Thu 13 November 2003]

RE: Crawler I actually got a hit with referer URL... [Thu 13 November 2003]

Lordy worked quicker than I thought, thanks for the feedback.... [Thu 13 November 2003]

Google API's I'm using the Google API's to query Google for pages... [Thu 13 November 2003]

Here's the link that is showing up in my referrers... This link: ...was in my... [Sun 16 November 2003]

War On 106 Exciting, seems being pissed off with bus route 106 is... [Wed 19 November 2003]

stellastarr* Stellastarr* play Islington Academy today, the venue in... [Mon 24 November 2003]

Achoo Back at work with the miserable remains of a cold...... [Mon 24 November 2003]

Baby, baby, where did the month go? I am amazed it's the 24th already! I forgot I have... [Mon 24 November 2003]

RE: stellastarr* Hiya... I just discovered your site while doing a search... [Mon 24 November 2003]

RE: stellastarr* p.s. my e-mail addy is: (on... [Mon 24 November 2003]

Property prices falling in Stokey This place (pictured) is next door but one to us, and... [Mon 24 November 2003]

Todays tasks Tweaked the calendar now so that when an event is added,... [Mon 24 November 2003]

A public holiday to celebrate us winning the world cup? come on Tessa, let's have it ... "We will look at all... [Mon 24 November 2003]

stellastarr* Last night's Stellastarr* gig at Islington Academy... [Tue 25 November 2003]

Stellastarr* THEY'RE ACE. [Tue 25 November 2003]

Perl / Excel Programming idea for the day! Instead of me trying to... [Tue 25 November 2003]

Perl and Excel Found some handy documentation at of all places. [Tue 25 November 2003]

RE: Crawler and I got one today from My site is... [Tue 25 November 2003]

Daily productivity Sorted out a mailing list oddity that was left over from... [Tue 25 November 2003]

Maybe Stokey prices aren't falling... Our neighbour on the other side has also just gone up... [Tue 25 November 2003]

Where does all this water come from? Water is still streaming into the flat, seems to be... [Wed 26 November 2003]

Want some shoes? Oh, and tickets to a cheeky ESP gig... [Wed 26 November 2003]

Darkness download! Got the option to sell this download through the site...... [Wed 26 November 2003]

Leaky roof The letting agency sent someone round to look at the... [Wed 26 November 2003]

RE: stellastarr* I agree (in a way!). I thought the 22s were good and I... [Thu 27 November 2003]

Ongoing Excel / PERL stuff The PERL Excel project is coming along nicely, it takes... [Thu 27 November 2003]

Siegfried and Roy Wondering if this "Montecore says Get The Horn"... [Thu 27 November 2003]

Hands off our 73! Just remembered, while having some smashing drinks in the... [Thu 27 November 2003]

Bus route 106 Got an email from my flatmate this morning: Got the... [Thu 27 November 2003]

Too many fields appear to be blank In my ongoing perl / excel investigations, I'm finding... [Thu 27 November 2003]

How to convert an Excel date to a UNIX date Excel stores a date as the number of days since the start... [Thu 27 November 2003]

Very popular with Shoreditch types And another competition for you! You have all entered the... [Fri 28 November 2003]

IPOD's Dirty Secret Not sure what IPOD's Dirty Secret actually is, there's... [Fri 28 November 2003]

Popdex Not to be confused with my very own , Popdex... [Fri 28 November 2003]

Auto unsubscribes for Barfly Hmm, getting there with the auto unsubscribes for Barfly... [Fri 28 November 2003]

Banner Ads Nice one, just got two and a half grand in for... [Fri 28 November 2003]

Doh! Should have checked right away, those lines in the excel... [Fri 28 November 2003]

Quicktime STILL can't watch it here, Quicktime won't install on... [Sun 30 November 2003]

Good work If you put them up on the web, post a link to them here,... [Mon 1 December 2003]

RE: stellastarr* Yeah, I went to this gig. I've seen Stellastarr* in every... [Wed 28 January 2004]

Hi Moker You're in the Ordinary Boys aren't you? [Thu 29 January 2004]

RE: Hi Moker Not on your nelly. Going to see Stellastarr* soon. It's... [Fri 30 January 2004]

Stellastarr new tour Stellastarr play Camden Electric Ballroom today, same... [Sat 31 January 2004]

RE: stellastarr* i hope you die of cancer [Tue 2 March 2004]

Upload a file [Tue 8 November 2005]

orlando bulgaria micropub follies new york hospital premier inn working from home pay day shares holiday sofia payers park center parcs raspberry pi go ape beetle harry potter studios mortgage tax tower bridge chambers wfh scottevest pizza vegan harbour arm share save docker inn doors ad blocker

Paul Clarke





Privacy policy