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:
Add Comment