Re: Excel automatically pulling data from Perl?

I've done that once (in Python though), but it was plain simple - Excel can read an HTTP url and will use a table returned there as the data. So, glue together something with HTTP::Server::Simple, and make Excel re-read that URL. Or fire up some VBA code to use Shell() to launch a Perl program periodically.

You add the HTTP data source as a real data source (Menu Data->External Data->HTML file->http://tilly.internal/magic_url). I believe there was a way to make Excel read a value into a single cell via HTTP but I don't find the code I used for that anymore.

Comment on Re: Excel automatically pulling data from Perl? Select or Download Code

Replies are listed 'Best First'.
Re^2: Excel automatically pulling data from Perl? by tilly (Archbishop) on Jun 28, 2007 at 15:28 UTC
Thank you, that works perfectly. :-)	[reply]
Re^2: Excel automatically pulling data from Perl? by BrowserUk (Patriarch) on Jun 29, 2007 at 06:11 UTC
That's really neat. I just tried it with OO-Calc and it works a treat. The menu option Insert->link_to_external_data accepts a url and presents you with a list of entites html_all, html_tableetc. Click that and your away. Nice. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. "Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."	[reply]