3 sheets tagged with "xml":

NB this spreadsheet will only work in Resolver One version 1.4 or later.

This spreadsheet and the accompanying script are based on one of the examples from the documentation for Python's XMLRPC library - see the "More information" link below.

The Python script, when executed either using CPython or using IronPython with the Python 2.5 libraries installed, runs as an XMLRPC server that exposes one very simple function, is_even, which takes a number and returns whether or not that number is even.

The spreadsheet uses some simple pre-constants user code to connect to this server, and then a column-level formula in column B (click on the column B header to see it) that calls the server to check the evenness of every number in column A.

This is a really simple example of something very powerful - it shows how you can call external XMLRPC services from within your spreadsheets.

Timetric is a website and web service for storing, searching, graphing and publishing the world's statistical data. It stores data as time series and lets you view graphs of the data plus manipulate and combine them in lots of interesting ways.

As well as making a huge amount of public data available you can also push your own data sets to Timetric and use their services to analyse them.

This example demonstrates the potential of using Resolver One as a client to interact with Timetric's services. You can fetch and view a chart of individual datasets and search their large bank of statistics.

As well as accessing Timetric this sample shows:

* Using the Python Oauth library from IronPython
* Working with the Timetric API
* Fetching and parsing CSV files
* Accessing an opensearch API
* Parsing XML (the Atom format responses to search queries)
* Drawing charts with ZedGraph
* Creating and selecting worksheets from button handlers
* Using MessageBox dialogs from user code

The download includes documentation on how to use it and how it works.

This Resolver One spreadsheet can update your twitter account, get your friend’s list or get the list of those who are following you.