Skip to end of metadata
Go to start of metadata

Powerful mechanism to get any data you like into Excel (SOA etc)

1. Get some XML which represents your data item
2. Write some XSL that turns your data item xml into a simple html table
3. Import that into an excel array, thus returning the value from your array formula

Get the item as an html table

Convert it to an array - taking care of the data types

Now write your top level function

Labels: