Convert HTML Table Into An Array Formula Result
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