I need an Excel 2002 (XP) Spreadsheet which can consume ANY webservice and displays the contents.
On opening the Excel spreadsheet asks for the SOAP webservice URL (.asp or .aspx or whatever) and then calls that webservice and displays the results. Don't ask for parameters, just keep this a simple and quick solution please.
The Excel spreadsheet doesn't need to display them 'pretty' it just needs to iterate through whatever XML is in the SOAP packet and then display that information in the Excel cells. If the XML is in a tree structure then simply indent the cells by one level so it looks slightly like a tree.
For an idea on how to write Excel code that consumes SOAP webservices, view this MSDN document:
[url removed, login to view]
When replying, please include your name, any similar experience you have, or why you believe you can do it.
This must use either the .NET platform OR MSXML 3 (not MSXML 4)
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components).
4) A working runnable Excel Spreadsheet which consumes and displays the output from *any* SOAP webservice it is pointed to.
.NET or MSXML 3
Excel 2002 (XP)