1 sheets tagged with "xmlrpc":

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.