Scripting News: Spreadsheet calls over the Internet?

Scripting News, the weblog started in 1997 that bootstrapped the blogging revolution.

Spreadsheet calls over the Internet?

I like having a spreadsheet around, but until Google came out with their browser-based spreadsheet, I hadn't used one in many years. I find Office too much software, and all the other spreadsheets I had learned either didn't run on my machine or weren't being actively maintained. Without thinking much I had stopped using them.

But now I use it for all kinds of little tasks that require an array of values, or a bit of calculation. Now I'd like to start building more of my life around a spreadsheet, to use it to monitor various processes on my servers, but to do this, there will have to be a protocol for plugging web apps into the spreadsheet.

Here's the syntax I imagine using:

[server].getPortfolioValue (username, password)

It would work just like a built-in spreadsheet function except the call would go out over the net, run the procedure on the indicated server, and display the value it returns, formatted according to how the spreadsheet author says it should be formatted.

The server url would include a protocol, server name, port and path. I would recommend doing XML-RPC first, it's the simplest, most uniformly implemented RPC out there. You'd have to do some form of SOAP, and extend REST with standards for serializing and de-serializing parameter lists and returned values (or you could adopt the serialization format from one of the other protocols).

Example: xmlrpc:\//rpc.fidelity.com:7092/

Interestingly, this is one of the demos Microsoft did for Multiplan for the IBM-PC in the early 80s when it was competing with Visicalc. Then, it was a good vision, but impractical. Today it's practical and would be very useful and would lead to many interesting apps, perhaps even businesses.

Last update: Thursday, June 3, 2010; 4:00:44 PM

~About the Author~

Dave Winer, 55, is a visiting scholar at NYU's Arthur L. Carter Journalism Institute. He pioneered the development of weblogs, syndication (RSS), podcasting, outlining, and web content management software; former contributing editor at Wired Magazine, research fellow at Harvard Law School, entrepreneur, and investor in web media companies. A native New Yorker, he received a Master's in Computer Science from the University of Wisconsin, a Bachelor's in Mathematics from Tulane University and currently lives in New York City.

"The protoblogger." - NY Times.

"The father of modern-day content distribution." - PC World.

One of BusinessWeek's 25 Most Influential People on the Web.

"Helped popularize blogging, podcasting and RSS." - Time.

"The father of blogging and RSS." - BBC.

"RSS was born in 1997 out of the confluence of Dave Winer's 'Really Simple Syndication' technology, used to push out blog updates, and Netscape's 'Rich Site Summary', which allowed users to create custom Netscape home pages with regularly updated data flows." - Tim O'Reilly.

Mail: scriptingnews1mail at gmail dot com.

Mar May