Perl / Excel

Home

Perl / Excel

Nov
252003
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 convince people that my system is simpler and more logical if they're still attached to their spreadsheets, what they'll start doing is using the spreadsheet still and then copying and pasting over to the web forms at the end, then they'll realise they're doing more work, so then they'll stop doing it altogether... SO, if for say the gig guide I can offer the option to just upload a spreadsheet, and have the computer do all the work, it'll save everyone a lot of time...

SO, need to find perl excel modules, there must be some out there... the next option would be just to say "please export your spreadsheet as a tab delimited file and then click here", but even that will be offputting to some...
TweetComment / reply

Upload a file



Glossary:

javascript: a major programming language of the internets, mostly how I make my living
8 Nov TweetComment / reply

Perl and Excel

Found some handy documentation at IBM.com of all places.
25 Nov TweetComment / reply

Paul Clarke's - I live and work in Hythe near Folkestone, Kent. married to Clare and father to two, I am a software engineer, and I do mostly javascript, Node, python, ruby, and php. I like pubs, 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 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]

David Devant cancelled Well, anyway, it seems to be not going ahead , it was... [Sun 16 November 2003]

Here's the link that is showing up in my referrers... This link: clarkeology.com/stokey/51/9/ ...was in my... [Sun 16 November 2003]

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

David Devant A post on this message board , seemingly by Vessel... [Sat 22 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: t_ferrino2k@yahoo.co.uk (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 IBM.com of all places. [Tue 25 November 2003]

RE: Crawler and I got one today from clarkeology.com 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 popex.com , Popdex... [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]

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

Paul Clarke

Links

Latest

Todo:

Projects

Privacy policy