I have created a web service that provides me with sales data from our corporate ERP system. We are going to use this to drive some "dashboards" showing this data graphically.
For testing/ evaluation I would like to use a web service like a custom function to populate individual fields in a spreadsheet. I can't see how to d this easily in MS Excel (2007) but wonders if OpenOffice Calc has a capability.
My hope/expectation is that I type in a call the web service in each cell and e web service reply (a sales number relating to the web service call is returned and displayed in the cell.
My web service is called something like this:
http://server:8080/SalesHistory?Year=2011&Month=10&Region=Europe&Channel=Web
As you can guess, this will return the value of sales for October'11 for the region/sales channel stated.